Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Qlik Sense - AND Mode

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.

5 Replies

Re: Qlik Sense - AND Mode

Hi,

Check this if it helps.

Generating AND, OR , NOT selection logic in Qlik Sense

Regards,

Kaushik Solanki

MVP
MVP

Re: Qlik Sense - AND Mode

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

Partner
Partner

Re: Qlik Sense - AND Mode

Hi Kaushik,

I did read that post but cannot do so.

Such method would work for a small amount of data.

Luminary
Luminary

Re: Qlik Sense - AND Mode

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

Partner
Partner

Re: Qlik Sense - AND Mode

Hello Juraj,

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

Thanks again