Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have the following data table sample:
System | A | B | C |
1 | Y | N | N |
2 | N | Y | Y |
3 | N | N | Y |
4 | N | N | N |
In one of my dashboards, I want a view to show Systems that are equal to A = Y or B = Y or C = Y. So in this example only System 1, 2 and 3 are should show.
Currently I have tried
=Count({< A = {'Y'} or B = {'Y'} or C = {'Y'}>} System)
But i just get an error in expression.
Thanks
Hi, the syntax can be: =Count({<A={'Y'}>+<B={'Y'}>+<C={'Y'}>} System)
So, differnet sets identified between <>, with + to make an OR between this sets
Hi, the syntax can be: =Count({<A={'Y'}>+<B={'Y'}>+<C={'Y'}>} System)
So, differnet sets identified between <>, with + to make an OR between this sets
Just posting Help link on things as there is further documentation there on what Ruben mentioned:
The following Design Blog may be helpful too:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
I am going to mark Ruben's post as the solution given you have not replied back, so I am assuming that worked.
Regards,
Brett