Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
Partner
Partner

Pivottable Measurements Groups AND Condition

Hi there,

 

I'm having a question:

I want a pivot table where the user can see, if a salespartner added  data, it's getting a yes ("ja"), if not its a no.
I can group these salespartners to Regions, and ONLY if EVERY sp in a region added data, there shall be a "yes" in the pivottable. Instead, as soon as there is ONE "yes" the whole region is set to "yes".

How can i fix this?

 

pivotBug.PNG

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Pivottable Measurements Groups AND Condition

Maybe something like this might work:

if(wildmatch(concat(aggr(if(Count(distinct [Date])>0,'Yes','No'), Vertriebspartner), ','), '*No*'), 'No', 'Yes')

- Marcus

View solution in original post

5 Replies
Highlighted
Employee
Employee

Re: Pivottable Measurements Groups AND Condition

What is current measure expression?

Highlighted
MVP & Luminary
MVP & Luminary

Re: Pivottable Measurements Groups AND Condition

You could try something like this:

if(count(Field) = count({< Field = {'no'}>} Field), 'Ja', 'Nein')

- Marcus

Highlighted
Partner
Partner

Re: Pivottable Measurements Groups AND Condition

Hi, the current expression is depending on the date. Only if they added something, a date exists.

if(Count(distinct [Date])>0,'Yes','No')      translated

Highlighted
MVP & Luminary
MVP & Luminary

Re: Pivottable Measurements Groups AND Condition

Maybe something like this might work:

if(wildmatch(concat(aggr(if(Count(distinct [Date])>0,'Yes','No'), Vertriebspartner), ','), '*No*'), 'No', 'Yes')

- Marcus

View solution in original post

Highlighted
Partner
Partner

Re: Pivottable Measurements Groups AND Condition

Holy!
That feels like magic!


Thank you so much Marcus!