Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cjzimm76
Contributor

Conditional Show for Alternate States

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?

3 Replies
cjzimm76
Contributor

Re: Conditional Show for Alternate States

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

Hi

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

Employee
Employee

Re: Conditional Show for Alternate States

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

Community Browser