Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an issue with Qlik Sense. I need to be able to show values that only match all the criteria I selected in a filter.
QlikView had a "AND-MODE" which does not seems to exist in Qlik Sense.
Is there any way in Qlik Sense to do so?
Thank you.
Gerald.
Hi,
Check this if it helps.
Generating AND, OR , NOT selection logic in Qlik Sense
Regards,
Kaushik Solanki
In the example that kaushik.solanki refers to the measure for the Skills could be done without Aggr() and GetSelectedCount like this:
If(
Concat(DISTINCT TOTAL <User> Skills,'/',Skills) = Concat(TOTAL DISTINCT Skills,'/',Skills)
,
Count(DISTINCT Skills)
)
Which can be read in a more natural language as:
If the "combination of all (TOTAL) distinct skills for a particular user" = "the combination of all distinct skills selected" then return the count of unique skills. The third parameter is necessary so the combination is sorted by skill for each of the Concat's
Hi Kaushik,
I did read that post but cannot do so.
Such method would work for a small amount of data.
Hello Gérald,
here's a simple tutorial how to achieve something similar to AND mode Field selections AND-mode for Market Basket Analysis
Hope this helps.
Juraj
Hello Juraj,
This seems much more like what I need. I will give it a shot and will get back to you.
Thanks again