Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     plotting null values on graph

Read-Only Read-Only Topic
Go
Search
Notify
Tools
plotting null values on graph
 Login/Join
 
<Thariq>
posted
Hi,
Please do provide a solution on this.How do we plot null values on to scatter graphs. have already tried with MISSING and GMISSING parameters. Gmissing is working only when we use 'SUM'. I need to 'PRINT' the passed fields directly on to the graph. I am getting " EDA/no data "when MISSING parameter applied to the graph. Here follows my code for reference.

DEFINE FILE GRAPH1
CST1/D20 MISSING ON=IF CUSTOMER EQ 'A' THEN PRICE ELSE MISSING ;
CST2/D20 MISSING ON=IF CUSTOMER EQ 'S' THEN PRICE ELSE MISSING;
CST3/D20 MISSING ON=IF CUSTOMER EQ 'D' THEN PRICE ELSE MISSING ;
END

SET LOOKGRAPH = SCATTER, GRID=ON
SET GTREND=ON
SET HAXIS=600, VAXIS=315,
SET GMISSVAL=MISSING
SET GMISSING=ON
GRAPH FILE GRAPH1
PRINT CST1 CST2 CST3
ACROSS VOLUME
ON TABLE SET ONLINE-FMT HTML
ON GRAPH SET GMISSING ON
ON GRAPH SET GRAPHSTYLE *

****STYE FOLLOWS****

ENDSTYLE
END


Help me out in reolving the issue.

Thanks!!!!
 
Report This Post
Larry Eiss
Member
posted Hide Post
Thariq,

See the code below.

I'm using VZERO=OFF and it runs OK. Let me know if the output is not what you are looking for.

Larry

----------------Begin Code---------------
-* File MISSING.fex
DEFINE FILE CAR
CST1/D20 MISSING ON=IF COUNTRY EQ 'ENGLAND' THEN SALES ELSE MISSING ;
CST2/D20 MISSING ON=IF COUNTRY EQ 'FRANCE' THEN SALES ELSE MISSING;
CST3/D20 MISSING ON=IF COUNTRY EQ 'JAPAN' THEN SALES ELSE MISSING ;
END

GRAPH FILE CAR
ON GRAPH SET LOOKGRAPH SCATTER
ON GRAPH SET GRID ON
ON GRAPH SET GTREND ON
ON GRAPH SET HAXIS 600
ON GRAPH SET VAXIS 315
ON GRAPH SET 3D OFF

-* When VZERO is OFF MISSING values are not shown as Zero
ON GRAPH SET VZERO OFF

PRINT CST1 CST2 CST3
ACROSS RC

ON GRAPH SET GRAPHSTYLE *
ENDSTYLE
END
-----------END CODE---------------
 
Posts: 20 | Location: IBI Corporate HQ, NY | Registered: May 13, 2003Report This Post
<Thariq>
posted
Hi Larry,

Thanks for your reply. But it is still showing the same 'EDA no/data' message. Attached is the code for reference.

SET SQLENGINE=SQLORA
SQL SQLORA
SELECT PRICE,VOLUME,CUSTOMER FROM TEST_TBL;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS CAR FORMAT ALPHA
END
-RUN

DEFINE FILE CAR
CST1/D20 MISSING ON=IF CUSTOMER EQ 'A' THEN PRICE ELSE MISSING;
CST2/D20 MISSING ON=IF CUSTOMER EQ 'S' THEN PRICE ELSE MISSING;
CST3/D20 MISSING ON=IF CUSTOMER EQ 'D' THEN PRICE ELSE MISSING;
END

GRAPH FILE CAR
ON GRAPH SET LOOKGRAPH SCATTER
ON GRAPH SET GRID ON
ON GRAPH SET GTREND ON
ON GRAPH SET HAXIS 600
ON GRAPH SET VAXIS 315
ON GRAPH SET 3D OFF

-* When VZERO is OFF MISSING values are not shown as Zero
ON GRAPH SET VZERO OFF

PRINT CST1 CST2 CST3
ACROSS VOLUME

ON GRAPH SET GRAPHSTYLE *
ENDSTYLE
END

Here if I use 'SUM' instead of 'PRINT',it will show the output. But I want only 'PRINT'.
Please do let me know where I am going wrong.
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     plotting null values on graph

Copyright © 1996-2020 Information Builders