0 Replies Latest reply: Jun 16, 2015 4:17 AM by Madhu Reddy RSS

    How to display dynamic straight table?

      hi ,

      Hi,

       

      I create straight table in qlikview . I want to display my straight table  dynamically according to my selections.

      see my data

       

      1.PNG

      2.PNG

      step1: I select pivot table

      3.PNG

       

      Step2: I take 2 dimensions

      8.PNG

      Step 3: I write expression in expression tab.

       

      4.PNG

       

       

      5.PNG

       

      Step 4: I take this data

      6.PNG

      but when I select month in list box I doesnot work. see this image.

      7.PNG

       

      I want to display straight table like below

       

      If I select march then display my straight table Jan feb mar.like below.

      Listbox
      Jan
      Feb
      Mar
      apr
      may
      jun

      Straight table.

      CountryJanFebmar
      India120001500020000
      Uk150002000025000
      Aus200002500030000

      If I select  Feb  in list box.

      List box
      Jan
      Feb
      Mar
      apr
      may
      jun

      Then straight table  display like below.

      countryJanFeb
      India1200015000
      Uk1500020000
      aus2000025000

       

       

      pls tell me  out how to display data like above.

                                             

                                                                         Thankyou,

      Regards

      madhu