Hi QlikView gurus - this is probably a simple question.
I have a list box:
I need an option where either "All Lines" can be checked, or any other combination of lines, but not both at the same time. Right now, it's working like this:
This returns very bad data.
Thank you in advance for your help!
Solved! Go to Solution.
I might have misunderstood your requirements, but here is what I have:
You are hiding all other selections and the exp is:
Let me know if this is what you are looking for.
Thanks, but that wasn't quite working for what I need. I think I need and either / or function so that "All lines" can't be chosen at the same time as any of the other lines, but any combination of other lines can be chosen. "All Lines" is a sum total of the other lines, so if it is chosen along with other lines it returns redundant data.
try to add a trigger on your field (on select)
Actions --> Select in field
if(Alt(SubStringCount(GetFieldSelections(Line, '-'), 'All lines'), 0)
,chr(34) & 'All lines' & chr(34),
chr(34) & GetFieldSelections( Line, chr(34) & '|' & chr(34) ) & chr(34)
When you select "All lines" or "All lines" and something else the trigger will select "All lines"
Thank you, but that's not working either. I attached the qvw below. It's the same issue with the "Metric" list box. If "Overall DT %" is chosen, user shouldn't be able to make other selections at the same time.