topic Re: Conditional Show for Alternate States in QlikView

Conditional Show for Alternate States

cjzimm76 — Thu, 18 Oct 2012 20:34:00 GMT

I'm trying to use the conditional show property for an object. I want the condition to be based on if the user has selected a value in a list box that is in an alternate state. How can I write a conditional show expression to accomplish this?

Say the alternate state is Alt1. The list box field is Year. I would have thought there was something like:

GetSelectedCount(<Alt1> Year) > 1

Had anyone tried this before?

Re: Conditional Show for Alternate States

cjzimm76 — Thu, 18 Oct 2012 20:46:36 GMT

Also I should note that the object with the conditional show is in a different alternate state than Alt1.

Re: Conditional Show for Alternate States

MayilVahanan — Thu, 18 Oct 2012 20:51:42 GMT

There is no option like that

Please check this link:

http://community.qlik.com/ideas/2340

But you can use like this..

Hope that help

Re: Conditional Show for Alternate States

Lee_Matthews — Thu, 14 Nov 2013 00:56:05 GMT

If you have a field in the default state that matches the one in the comparison state, you can count all values in the field from the default state and subtract a distinct count from the comparison state. If the value is less than zero, then something has been selected. Its not pretty, but here is an example:

Count(distinct {[Compare1]} Field) - (GetSelectedCount(Field)+GetAlternativeCount(Field)) < 0