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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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