Qlik Community

Qlik Sense App Development

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

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

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*"}

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

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

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

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

Community Browser