Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
a1020583
New Contributor II

How to use qliksense set analysis to choose "A" card only

Hi guys,

i have some question about my data

ex.

there are three people Jay ,Frank, Peter

ABC represent  each of card kind

Jay : only A card

Frank : A,B card

Peter : A,B,C  card

i want to select who only have A card

regard ,

Jay

1 Solution

Accepted Solutions
ali_hijazi
Honored Contributor

Re: How to use qliksense set analysis to choose "A" card only

suppose the following is your data:

load * Inline [

person, card

jay,A

frank,A

frank,B

peter,A

peter,B

peter,C

Elie,A

]

Create a pivot table with person as dimension

then use the following expression:

only({<person={"=count(card)=1 and only(card)='A'"}>} card)

then you will get your desired result

test_count.PNG

hope this helps

I can walk on water when it freezes
6 Replies
MVP
MVP

Re: How to use qliksense set analysis to choose "A" card only

How about this clause in your set expression?

ABC = {"*A*"}

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
ali_hijazi
Honored Contributor

Re: How to use qliksense set analysis to choose "A" card only

suppose the following is your data:

load * Inline [

person, card

jay,A

frank,A

frank,B

peter,A

peter,B

peter,C

Elie,A

]

Create a pivot table with person as dimension

then use the following expression:

only({<person={"=count(card)=1 and only(card)='A'"}>} card)

then you will get your desired result

test_count.PNG

hope this helps

I can walk on water when it freezes
a1020583
New Contributor II

Re: How to use qliksense set analysis to choose "A" card only

Hi

What function  can i use

If i want to count how many people in A

ali_hijazi
Honored Contributor

Re: How to use qliksense set analysis to choose "A" card only

=count({<person={"=count(card)=1 and aggr(only(card),person)='A'"}>} person)

I can walk on water when it freezes
jonnieyacoub
Contributor

Re: How to use qliksense set analysis to choose "A" card only

count({<[card]={'A'}>} card)

ali_hijazi
Honored Contributor

Re: How to use qliksense set analysis to choose "A" card only

no this expressions counts all users who got A but Jay wants to count the persons who got only A i.e. 1 card and that card is A

I can walk on water when it freezes
Community Browser