Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

hkg_qlik
Contributor II

SET ANALYSIS

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,

H

Tags (2)
1 Solution

Accepted Solutions
rustyfishbones
Honored Contributor II

Re: SET ANALYSIS

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)

4 Replies
mov
Esteemed Contributor III

Re: SET ANALYSIS

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)

israrkhan
Valued Contributor II

Re: SET ANALYSIS

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)

hkg_qlik
Contributor II

Re: SET ANALYSIS

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 

rustyfishbones
Honored Contributor II

Re: SET ANALYSIS

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)

Community Browser