2 Replies Latest reply: May 3, 2017 9:38 AM by vamsi krishna RSS

    How to do this in pivoting

    vamsi krishna

      Hi ,

      I have generated a heat map in qlikview and pivot it  and it looks nice.

      Now i am pullling that sort of pivot table to nprinting.

      I am aware that I have to convert to straight table and do then pivot it in inprinting .

      I have fairly managed it till this point but unable to get what I want .

      How to get AM and PM to the sides...like 0 to 23 hours.

      If some one can able to help me out pls.

      Figure 1 : Qlikview pivot heat map

      Figure 2 ; Nprinting pivot table

      figure 3 : Output in excel,


      Many thanks.