# Qlik Sense App Development

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

Tags (3)
1 Solution

Accepted Solutions
Honored Contributor

## 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

I can walk on water when it freezes
6 Replies
MVP

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

ABC = {"*A*"}

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

## 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

I can walk on water when it freezes
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

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
Contributor

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

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

Highlighted
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