Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kprotrka
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?

 

 

 

kprotrka_3-1642510507426.png

 

kprotrka_2-1642510470954.png

 

 

 

0 Replies