Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Qliksense

Hi ,

I want to count the distinct people id in a pivot  table for each column , also i want to exclude the people id's that were present in the prior columns of the pivot table.

i'm using the below expression for getting the count:

COUNT(DISTINCT {<[Cumulative LTV - First Order Date_MS]={">=$(vMinCM)<=$(vMaxCM)"}>} [Cumulative LTV - PeopleID])

This count includes id's from the previous columns which i dont want.

would like to achieve this through expression.

Attached is the image of the current setup.

Any help is much appreciated.

 

 

 

 

0 Replies