Hi All,

I have created a visualization (Info-assist+) for bar chart and now i want to show top 5 cars by sales (using car sample file) but I am unable to apply limit in the visualization , Limit option is disabled . Is this any configuration issue with my machine or we can not limit the data points in visualizations.

This message has been edited. Last edited by: FP Mod Chuck,

I think that's by design. You can still sort but in visualization mode, the end user can determine what part of the chart they want to include or exclude by brushing the mouse over the bars they want to keep.

Still not an elegant solution, but is that what you're looking for (or similar to this) ?

TABLE FILE CAR
SUM RETAIL_COST
BY COUNTRY
BY CAR
ON TABLE HOLD AS TMP FORMAT FOCUS
END
-RUN

TABLE FILE TMP
SUM RETAIL_COST
BY HIGHEST RETAIL_COST NOPRINT
BY TOTAL COMPUTE RNK /I2 = RNK + 1; NOPRINT
BY COUNTRY
BY CAR

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE SET BYDISPLAY ON
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     
     DEFMACRO=RANKGE6,
     MACTYPE=RULE,
     WHEN=RNK GE 6,
$
     GRAPHTYPE=DATA,
     COLUMN=N5,
     GRAPHCOLOR='BLACK',
$
     GRAPHTYPE=DATA,
     COLUMN=N5,
     GRAPHCOLOR='WHITE',
     MACRO=RANKGE6,
$
ENDSTYLE
END

quote:

till not an elegant solution, but is that what you're looking for (or similar to this) ?

Hi Martin ,

Thanks for your quick reply ,
Actually i was creating visualization(bar chart) and below is the sample code of my visualization
In this i need to show only top 5 values,

  SET UNITS=PIXELS
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET EMPTYREPORT=ON

SET ARGRAPHENGINE=JSCHART

COMPOUND LAYOUT PCHOLD FORMAT AHTML
SECTION=Section_1, LAYOUT=ON, PAGESIZE=E, ORIENTATION=PORTRAIT, SHOW_GLOBALFILTER=OFF, ACTIVE_UNITS=PTS, PAGECOLOR=RGB(255 255 255), ARGRAPHENGINE=JSCHART, $
PAGELAYOUT=1, NAME='Page 1', TEXT='Page 1', LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $
COMPONENT=Cache_1, COMPONENT-TYPE=REPORT, POSITION=(1.0 1.0), DIMENSION=(3.0 4.0), HIDDEN=ON, ARFILTER_TARGET='*', METADATA='VERSION:1.0', $
COMPONENT=Chart_1, COMPONENT-TYPE=GRAPH, POSITION=(0.0 0.0), DIMENSION=(100.0% 100.0%), ARREPORTSIZE=DIMENSION, ARFILTER_TARGET='*', METADATA='VERSION:1.0', $
OBJECT=HBOX, NAME='HBox_1', CONTENT='Chart_1', POSITION=(0.0 0.0), DIMENSION=(100.0% 100.0%),$
END

SET COMPONENT=Cache_1
-*component_type report
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE ibisamp/car
PRINT CAR.ORIGIN.COUNTRY
WHERE RECORDLIMIT EQ 1
WHERE READLIMIT EQ 1
HEADING
""
ON GRAPH PCHOLD FORMAT PDF
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET WEBVIEWER ON
ON TABLE SET ARCACHEMODE NOEXTRACT
ON TABLE SET EMBEDHEADING ON
ON TABLE SET PREVIEW ON
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='WebFOCUS InfoDiscovery', HIDDEN=ON, PAGESIZE=E, AR_SHOW_MENUBAR=POPOUT, ARCACHEINCLUDE='', ARGRAPHENGINE=JSCHART, $
ENDSTYLE
END

SET COMPONENT=Chart_1
-*component_type graph
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE ibisamp/car
-* Created by Info Assist for Graph
SUM CAR.BODY.SALES
BY TOTAL CAR.BODY.SALES NOPRINT
BY CAR.COMP.CAR
HEADING
""
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET WEBVIEWER ON
ON GRAPH SET ARCACHEMODE NOEXTRACT
ON GRAPH SET EMBEDHEADING ON
ON GRAPH SET GRWIDTH 1
ON GRAPH SET HAXIS 100.0
ON GRAPH SET VAXIS 100.0
ON GRAPH SET PREVIEW ON
ON GRAPH SET UNITS INCHES
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENID_Default.sty,$
TYPE=REPORT, TITLETEXT='Bar Stacked1', PAGESIZE=E, AR_SHOW_MENUBAR=POPOUT, ARREPORTSIZE=DIMENSION, ARFILTER_TARGET='*', CHART-ORIENTATION=VERTICAL, CHART-SERIES-LAYOUT=stacked, ARGRAPHENGINE=JSCHART, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);

*END
ENDSTYLE
END

COMPOUND END

quote:

Originally posted by BabakNYC:
I think that's by design. You can still sort but in visualization mode, the end user can determine what part of the chart they want to include or exclude by brushing the mouse over the bars they want to keep.

Thanks Babak I tried this in other users machine , and all user has limit option disabled .
I think you are right that's by design .

You could do the aggration before:

TABLE FILE CAR
SUM SALES
BY HIGHEST 5 TOTAL SALES
BY MODEL
ON TABLE HOLD AS BLABLA FORMAT FOCUS INDEX MODEL
END

And inner join to it with your visualisation. Note that this migth have some performance challanges.

Hi Frans,

It does not works , As i am creating Visualization,

Login to Client--> select Domain --> Right click --> new--> select Visualization .

Here i want to apply limit.

Chaudhary

Visualizations a different paradigm and are meant for data mining if you really want to apply a limit without creating a hold file first then just do a chart