Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Also I should note that the object with the conditional show is in a different alternate state than Alt1.
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
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