Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Help with Calculated Condition

Hi, I want to set a calculated condition to only display my object if at least 1 of 3 fields are selected.

field 1 (any of the 'Sub Fields' within [Retail Group])

Field 2 ([Cust Name])

Field 3 (StoreNumber)

I have tried :

GetSelectedCount ([Retail Group])>0

This works, but only for Retail Group. I tried adding in the other 2

GetSelectedCount ([Retail Group])>0 + GetSelectedCount ([Cust Name])>0 + GetSelectedCount ([StoreNumber])>0

This didn;t work.

Any ideas?

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi,

Try

GetSelectedCount ([Retail Group]) > 0 OR GetSelectedCount ([Cust Name]) > 0 OR GetSelectedCount ([StoreNumber]) > 0


Regards.

View solution in original post

1 Reply
Miguel_Angel_Baeyens

Hi,

Try

GetSelectedCount ([Retail Group]) > 0 OR GetSelectedCount ([Cust Name]) > 0 OR GetSelectedCount ([StoreNumber]) > 0


Regards.