topic Re: SET ANALYSIS in QlikView

SET ANALYSIS

hkg_qlik — Wed, 13 Nov 2013 19:03:02 GMT

Hi all,

I am having issue with a SET ANALYSIS applied on a bar chart.

=count({1<[Stock Type] = {'S'},MFG_SOURCE_LOCATION_ID = {'PR01'}, [Area Name] = >}MSG_PROCESSED_FLG)

But if we use 1 in the above SET analysis expression that will not allow the expression to change if I select AREA NAME it is not giving me the right count for that particular AREA NAME.

The reason I am keeping 1 is because I want to display all the DIMENSION - Quarter-Year for the entire data-sheet at all time.

Any suggestions...

Thanks,

Re: SET ANALYSIS

Anonymous — Wed, 13 Nov 2013 19:08:05 GMT

Try

[Area Name] =P( [Area Name] )

Edit: Or maybe you don't use 1 but instead use [Quarter-Year]=

count({<[Stock Type] = {'S'},MFG_SOURCE_LOCATION_ID = {'PR01'}, [Quarter-Year]= >}MSG_PROCESSED_FLG)

Re: SET ANALYSIS

israrkhan — Wed, 13 Nov 2013 19:22:42 GMT

try like above post, as Michael Said, if your [Quarter-Year] is one field.

if Quarter and Year are separate fields then try like below

=count({<Year= , Quarter= , [Stock Type] = {'S'}, MFG_SOURCE_LOCATION_ID = {'PR01'}>} MSG_PROCESSED_FLG)

Re: SET ANALYSIS

hkg_qlik — Wed, 13 Nov 2013 20:04:30 GMT

Thank you all, But if I select a Quarter-Year or Month or date in the filter box it is narrowing the results. At any given time all Quarter-Year should be visible and only change when an AREA NAME is selected

Re: SET ANALYSIS

rustyfishbones — Wed, 13 Nov 2013 20:10:15 GMT

Well then you need to add all Date Fields to your set like

=count({<Year= , Quarter=, Week=,Month=,Date= , [Stock Type] = {'S'}, MFG_SOURCE_LOCATION_ID = {'PR01'}>} MSG_PROCESSED_FLG)