Skip to main content
Announcements
The New Qlik Learning Experience is Here! GET STARTED
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Set Expression

Hi Friends

I have follwing data in QV table and I want to write a set expression to the results shown below in my pivot table

Screenshot_3.png

1. count(distinct {<CLASS={'FR'}>} CUSTOMER) gives me the desired result. Kindly help me to write me 2 and 3 expression

1 Solution

Accepted Solutions
sunny_talwar

May be this

2. Count(DISTINCT {<CUSTOMER= {"=CLASS = 'FR' "}>} CUSTOMER)

3. Count(DISTINCT {<CLASS={'FR'}>} CUSTOMER) - Count(DISTINCT {<CUSTOMER= {"=CLASS = 'FR' "}>} CUSTOMER)

View solution in original post

1 Reply
sunny_talwar

May be this

2. Count(DISTINCT {<CUSTOMER= {"=CLASS = 'FR' "}>} CUSTOMER)

3. Count(DISTINCT {<CLASS={'FR'}>} CUSTOMER) - Count(DISTINCT {<CUSTOMER= {"=CLASS = 'FR' "}>} CUSTOMER)