topic Re: Qlik Sense - AND Mode in QlikView

Qlik Sense - AND Mode

gerald_lebret — Wed, 24 Jan 2018 11:44:35 GMT

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.

Re: Qlik Sense - AND Mode

kaushiknsolanki — Wed, 24 Jan 2018 11:59:22 GMT

Hi,

Check this if it helps.

Generating AND, OR , NOT selection logic in Qlik Sense

Regards,

Kaushik Solanki

Re: Qlik Sense - AND Mode

petter — Wed, 24 Jan 2018 13:32:21 GMT

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

Re: Qlik Sense - AND Mode

gerald_lebret — Thu, 25 Jan 2018 15:20:25 GMT

Hi Kaushik,

I did read that post but cannot do so.

Such method would work for a small amount of data.

Re: Qlik Sense - AND Mode

juraj_misina — Thu, 25 Jan 2018 15:35:15 GMT

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

Re: Qlik Sense - AND Mode

gerald_lebret — Thu, 25 Jan 2018 19:23:57 GMT

Hello Juraj,

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

Thanks again