topic Re: Alternate State Issue in QlikView

Alternate State Issue

pradnyat — Wed, 12 Nov 2014 13:36:33 GMT

Hi All,

I am facing one tricky issue.

I have 1 straight table for which I am using Alternate State named 'Alternate State1' .

I have 1 dimension named 'Contract'. My requirement is the Straight table should be displayed only when no contract is selected i.e

in layout I need to add expression as :

getselectedcount(Contract)=0

In normal situations this condition will work , but as I am using Alternate State for the chart, Contract selections are not affecting on that table, and we can't use the ($) symbol in layout expression to affect based on current selection as this is not feasible in getSelectedCount expression.

Is there any other way to make this work?

Thanks in Advance ...!

Re: Alternate State Issue

Gysbert_Wassenaar — Wed, 12 Nov 2014 13:39:39 GMT

In QV 11.20 SR8 the getselectedcount function accepts an additional parameter for the alternate state:

=GetSelectedCount(Contract ,'StateA')

If that version is not available and upgrading not an option you can do a check only if the number of possible values is not limited by selections in other fields: =if( count({StateA}distinct Contract) = fieldvaluecount('Contract'), 1, 0)

Re: Alternate State Issue

pradnyat — Wed, 12 Nov 2014 13:46:10 GMT

Thanks Gysbert,

But we are using QV 11.20 SR5. So, this function is not working there.

Is there any other workaround for this.

Re: Alternate State Issue

pradnyat — Wed, 12 Nov 2014 13:56:08 GMT

We can't use if( count({StateA}distinct Contract) = fieldvaluecount('Contract'), 1, 0) function as the data is restricting by other field selections.

Re: Alternate State Issue

pradnyat — Wed, 12 Nov 2014 14:44:14 GMT

Is there any workaround for this ??

Re: Alternate State Issue

avkeep01 — Mon, 30 May 2016 07:06:01 GMT

Hi PradnyaT‌,

I had the same issue, you can try using

COUNT(DISTINCT {[StateA]} Contract) = COUNT(DISTINCT {1} Contract)

In this case when there are no selections made in StateA the count of the contracts should be the same as alle the contracts (state =1 is ignore all selections). When there is a selection made then the count of the contracts is unequal to the count of all the contracts.

regards