6 Replies Latest reply: Feb 1, 2018 5:31 AM by Ali Hijazi

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

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

ABC = {"*A*"}

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

suppose the following is your data:

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

• 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

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

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

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

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

• 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