# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Partner - Contributor III

## Count problem

Hello,

first of all I apologize because I can't upload an example app of this matter. So I'm going to write a paralel example of my problem.

Imagine a table with the following fields:

MONTH: month when a person has travelled

PERSON: person who has travelled

Persons can travel each month for business, for pleasure, both, or no travel. So records would seem like that:

JANUARY - PERSON1 - PLEASURE

FEBRUARY - PERSON2 - PLEASURE

...

I need to configure a pie chart showing persons that never has travelled for pleasure. In my example data would be a pie chart showing 1 person with no pleasure travel (PERSON3) and 2 persons with some pleasure travel (PERSON1 and PERSON2).

I've been trying with a "PleasureTravelCounter" 0/1, but I don't get it.

Any help in spite of my explanation?

Best regards,

David.

1 Solution

Accepted Solutions

Ah, right. Qlik Sense. My mistake.

Use a synthetic dimension: =valuelist('Pleasure','No Pleasure')

And one expression:

=If(valuelist('Pleasure','No Pleasure')='Pleasure',

Count({<TRAVELTYPE={'PLEASURE'}>} distinct PERSON),

Count({<PERSON=E({<TRAVELTYPE={'PLEASURE'}>}PERSON)>} distinct PERSON)

)

talk is cheap, supply exceeds demand
7 Replies

Try a pie chart with two expressions:

No pleasure: Count({<PERSON=E({<TRAVELTYPE={'PLEASURE'}>}PERSON)>} distinct PERSON)

Pleasure Count({<TRAVELTYPE={'PLEASURE'}>} distinct PERSON)

talk is cheap, supply exceeds demand
Partner - Contributor III
Author

Thank you gwassenaar! I didn't know E() and P() functions and they seem to be very useful

I think we almost get it. My pie has a dimension "Pleasure" / "Not pleasure" because the table records have a flag as follows:

JANUARY - PERSON1 - BUSINESS - "No pleasure"

JANUARY - PERSON1 - PLEASURE - "Pleasure"

JANUARY - PERSON2 - BUSINESS - "No pleasure"

FEBRUARY - PERSON1 BUSINESS - "No pleasure"

FEBRUARY - PERSON2 - PLEASURE - "Pleasure"

FEBRUARY - PERSON3 - BUSINESS - "No pleasure"

Count({<PERSON=E({<TRAVELTYPE={'PLEASURE'}>}PERSON)>} distinct PERSON)

then the full pie is showing correctly how many people has not travelled for pleasure, that's works fine! But it fills the whole pie and I don't know how to show the other pie section with persons that have travelled for pleasure.

I am use to working with one dimension and one measure in pies, so I don't know how to manage with both expressions you give me (the one for pleasure and the one for no pleasure).

Best regards,

David.

Don't use any dimensions and the two expressions I posted above.

talk is cheap, supply exceeds demand
Partner - Contributor III
Author

If I don't use any dimension the following message appears: "Incomplete visualization".

I've tried with putting "No pleasure" in one measure and "Pleasure" in the alternative measure. I'm working with Qlik Sense 3.

Ah, right. Qlik Sense. My mistake.

Use a synthetic dimension: =valuelist('Pleasure','No Pleasure')

And one expression:

=If(valuelist('Pleasure','No Pleasure')='Pleasure',

Count({<TRAVELTYPE={'PLEASURE'}>} distinct PERSON),

Count({<PERSON=E({<TRAVELTYPE={'PLEASURE'}>}PERSON)>} distinct PERSON)

)

talk is cheap, supply exceeds demand
Partner - Contributor III
Author

Perfect! This kind of solution with synthetic dimension looks great!

Thank you gwassenaar

Partner - Contributor III
Author

Ooops, the pie chart is OK but it doesn't work as a filter. I mean I can't click in une pie section and filter that persona that has not travelled by pleasure. Can this be solved?

Tags