Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trying to find the right amount of people in pivot table

Hi,

In my table header i need to show the number of people where there 'rfte' is different from the 'delta van nbfte' (nbfte-rfte). As you can see in my picture the count isn't right. The 'rfte' ain't always 0,00 i just selected this so you could clearly see it ain't the right amount of people.
The formula i'm using is:

'Delta van de NBFTE - Aantal: '&



sum(if(aggr(count(distinct naam_en_voornaam),rfte)<>$(vDelta),1,0) )

vDelta = nbfte - rfte

error loading image

If somebody knows the right formula, please help 🙂

0 Replies