1 Reply Latest reply: Sep 3, 2013 7:35 AM by Juan Pedro Hidalgo RSS

    Dynamic Report with 2 header columns

      Hi,

       

      I am working on a dynamic report with following layout, consists of 2 high level column headerand subsidiary column headers.

       

      Summer and Winter is the actual data of a field called "Season", same as the Year. Upon selection of Summer / Winter / both in the list (or a button as an alternative), the report will show corresponding columns as follow.

       

      Both Selected.

       

       Summer 2013 VS Summer 2014Winter  2013 VS Winter 2014
      YearJunJulAugSepOctNovDecJanFebMarAprMay
      2013102030302010506040201010
      2014104050402040000000

       

      "Summer" Selected

       

       Summer 2013 VS Summer 2014
      YearJunJulAugSepOctNov
      2013102030302010
      2014104050402040

       

      Therefore, the header title "Summer 2013 VS Summer 2014" is actually a customized string which will change upon different selection on Fields.

       

      I tried to use the Pivot table but it fails as the "Zero" value cannot be suppressed and I cannot customized the header columns' title .

       

       SummerWinter
      YearJunJulAugSepOctNovDecJanFebMarAprMayJunJulAugSepOctNovDecJanFebMarAprMay
      2013102030302010000000000000506040201010
      2014104050402040000000000000000000

       

      When I go with the Strainght table, it would not allow to have the header column.

       

      It's a big headache for me right now as .

       

      May I have your guys's advice is the above requirement feasible in QlikView? And how can it be achieved?

       

      Much appreciated, Wish you all a nice day!!