topic Re: Table Style in QlikView

Table Style

emteam162 — Mon, 08 Jul 2013 10:01:18 GMT

Hi All,

I want to present my table on QlikView as :

Please, Share if you have any idea to that.

Many thanks

Emteam

Re: Table Style

Gysbert_Wassenaar — Mon, 08 Jul 2013 13:12:14 GMT

Give up. You won't be able to create that layout in Qlikview. Create two pivot tables; one with the months and one with the quarters. Export both to excel and create the layout you want in excel by combining the data from the two exported tables. Qlikview is not a spreadsheet. Trying to use it as one will be extremely frustrating.

Re: Table Style

emteam162 — Tue, 09 Jul 2013 10:20:22 GMT

Hi Gysbert Wassenaar

Thanks for your answer

and I created two pivot tables as you just say, and create Macro to export to Excel and i have what i want

Many thanks.

Emteam