Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

make a sheet visible only if more than 3 filters are selected

Hi

Is it possible to show a sheet only if 3 filters are selected. plz let me know if its possible.

Regards

Sagar Gupta

3 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     how many filters you have?

     you need to frame expression like below and which is to be placed in Sheet properties-->General-->conditional expression

     =RangeSum(if(GetSelectedCount(Field1),1),if(GetSelectedCount(Field2),1),if(GetSelectedCount(Field3),1),

          if(GetSelectedCount(Field4),1),if(GetSelectedCount(Field5),1),if(GetSelectedCount(Field6),1))>3

Celambarasan

johnw
Champion III
Champion III

This might work:

substringcount(getcurrentselections(),':')>=3

Anonymous
Not applicable
Author

  substringcount(getcurrentselections(),':')>=3

That's a nice solution John.

Works perfect here.