Qlik Sense - AND Mode

[gerald_lebret]

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.

[kaushiknsolanki]

Hi,

Check this if it helps.

Generating AND, OR , NOT selection logic in Qlik Sense

Regards,

Kaushik Solanki

[petter]

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

[gerald_lebret]

Hi Kaushik,

I did read that post but cannot do so.

Such method would work for a small amount of data.

[juraj_misina]

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

[gerald_lebret]

Hello Juraj,

This seems much more like what I need. I will give it a shot and will get back to you.

Thanks again