2 Replies Latest reply: Apr 25, 2013 4:23 AM by Vijay Jagjivan RSS

    Chart calculation at two levels

    Vijay Jagjivan

      Hi, i am trying to show values in a single chart without the 2nd value repeating in the AP Value expression. see attached example.

       

       

       

      Vendor     Employee     Employee Value     Vendor Value

       

      A               1                    10                      

      A               2                    5    

      A               3                    8

      Total A                                23                                       25

      B               4                    8                   

      B               5                    5                             

      B               6                    6              

      Total B                           19                                            20

       

      Total                              42                                             45

       

      when i create this in Qlik it shows the vendor value in each row and i need the chart to show as above.

       

       

      thanks