Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Partner
Partner

Re: Calculation condition possible values, multiple values

This would have the same built in mistake where if something has Value5 as well as Value1 it would get a Flag

Highlighted

Re: Calculation condition possible values, multiple values

How? Value1 will have Flag 1, and Value5 will have Flag 0... and Min(Flag) = 0?

Partner
Partner

Re: Calculation condition possible values, multiple values

What if you do a comparison like the one I've done below? In my quick test it seems to work as desired.

if(
 Concat(DISTINCT Field1, ', ') 
  = 
  Concat({< Field1 *= {'Value1', 'Value2'}>}DISTINCT Field1, ', ')
 ,1,0)

 I've attached my test qvw app

???
Celebrating my 300 accepted solution in the Qlik Community
???
Partner
Partner

Re: Calculation condition possible values, multiple values

Oh, I didn't see the last part. That might actually be it!

Partner
Partner

Re: Calculation condition possible values, multiple values

Thank you for your time and help!