Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Highlighted
MVP & Luminary
MVP & Luminary

Re: Qlik Sense - AND Mode

Hi,

Check this if it helps.

Generating AND, OR , NOT selection logic in Qlik Sense

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
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

Highlighted
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.

Highlighted
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

Highlighted
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