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

[a1020583]

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

[jonathandienst]

How about this clause in your set expression?

ABC = {"*A*"}

[ali_hijazi · Accepted solution]

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

hope this helps

[a1020583]

Hi

What function  can i use

If i want to count how many people in A

[ali_hijazi]

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

[Anonymous]

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

[ali_hijazi]

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