7 Replies Latest reply: Apr 10, 2017 9:26 PM by Sunny Talwar RSS

    Strange pivot table behavior

    Aleksandrs Jemeljanovs

      Greetings to the community!

      I struggle with the following Pivot table behavior:

      Screenshot 101: Order Month-Project-Product, the TOTAL<Month> gives me the right values;

      101.PNG

      Screenshot 102: Order Product-Month-Project, the TOTAL<Month> gives the right values when all the levels are open,

      102.PNG

      however

      Screenshot 103: same order, but when I close one of the drills (part. 'Door'), I get wrong total values.

      103.PNG

      What is wrong here - either it's me and a lack of understanding of Qlik features or is it a bug?

      I've attached the the app with this table.