Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
greend21
Contributor II

Alternate States and Set Analysis

I have a chart where I had to put a few listboxes for this chart in an alternate state so that the selections don't affect the other sheets. This is so that the charts can always have these defaults selected in accesspoint. I currently have NUM(Count({BillingSummary<InFRoll13Flag={1}>}DISTINCT(InFPolicyNumber)), '#,##0') for my set analysis so that it picks up the selections made by these list boxes that are in the alternate state. The issue with is the pivot will not filter if I make a selection within the pivot itself or in a listbox that is in the default state. Is there a way to have the set analysis recognize selections made in the default state AND in the alternate state?

ShowInFCount, ShowInFELS, and ShowInFFarm are the three areas where selections are made in alternate states.

1 Solution

Accepted Solutions

Re: Alternate States and Set Analysis

Try this

Num(Count({BillingSummary<InFRoll13Flag = {1}> * $<InFRoll13Flag = {1}>}DISTINCT InFPolicyNumber), '#,##0')

View solution in original post

5 Replies

Re: Alternate States and Set Analysis

Try this

Num(Count({BillingSummary<InFRoll13Flag = {1}> * $<InFRoll13Flag = {1}>}DISTINCT InFPolicyNumber), '#,##0')

View solution in original post

greend21
Contributor II

Re: Alternate States and Set Analysis

Thanks Sunny! After this worked I noticed just Num(Count({BillingSummary<InFRoll13Flag = {1}> * $}DISTINCT InFPolicyNumber), '#,##0') will also work. I thought I was going to have to list out the fields I wanted from the alternated state with :: or something like that. This is much easier.

Re: Alternate States and Set Analysis

Does this still work if you make a selection in InFRoll13Flag within the default state? If you are not going to make selection in that field... then you are good here... but if you make selections, the expression that I gave will work different then the expression that you have (I believe)

greend21
Contributor II

Re: Alternate States and Set Analysis

I agree that I think would need what you suggested if I were to make a selection in that field but no, that is an indicator to make sure the data is within a rolling 13 month period. No selections will be made in InFRoll13Flag outside of the set expression.

Re: Alternate States and Set Analysis

Then you have nothing worry about

Best,

Sunny