Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Pivot Table

I have one pivot table where I am using following formula:

sum(Aggr(Count(DISTINCT {<[Abrechnungsplanhilfe.VORRAT]-={'Endabgerechnet', 'Erledigt'}>} [Abrechnungsplanhilfe.VORRAT]), [Abrechnungsplanhilfe.OIDVARTKOMBI]))

The total result is OK, but wrong splitted. For example,offen i wrong at the beginning, but after the filtering the offen I get the right value.


First screenshot is wrong and the second one is correct.


What is the reason for that?










0 Replies