topic Show/hide a Text object using multiple selections in QlikView

Show/hide a Text object using multiple selections

Eagle71 — Mon, 23 May 2022 20:37:22 GMT

I want a text object to display if certain criteria are selected, otherwise stay hidden. Criteria is Status for which there are 4 possible selections. So status list box contains A,B,C,D. When Status is C and D textbox is to display. Problem is using Get Selected Count if the status is A and B the text box displays since GetSelectedCount evaulates to 2. How can I create a condition where one box displays if Status is C and D and a different text box displays if Status is A and B? Sorry If I should have posted elsewhere.

Re: Show/hide a Text object using multiple selections

edwin — Wed, 25 May 2022 21:59:42 GMT

use concatenate distinct of the values then test if equal to what you want:

if(concat(distinct Dim,'|',Dim)='C|D',...

Re: Show/hide a Text object using multiple selections

Eagle71 — Fri, 27 May 2022 18:49:31 GMT

In conditional area used : =(concat(distinct Dim,'|',Dim)='C|D') and worked perfectly!