topic Re: Same in QlikView

Same

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

PLease find the attachment of the sample qvw

I have two leveles Level1 and Level2

I have two charts straight table and pivot table ..

If u look at the straight tabe the way IND or LND ...is diplayed for each level

where as for Pivot it is not displaying .

Cant i make Pivot table to appear in the same way as that of Straight table ?

Re: Same

adamdavi3s — Thu, 23 Mar 2017 11:39:53 GMT

Hi John,

Could I just ask why?

There isn't a simple option to do this but I am sure a workaround can be found somehow, but I don't really understand quite why you would want to do this

Re: Same

smilingjohn — Thu, 23 Mar 2017 11:41:40 GMT

Becuase i will be having a month column which i will be taking as horzontal by draging it up ,thats why i need pivot table

Thanks

Re: Same

awhitfield — Thu, 23 Mar 2017 11:44:07 GMT

Same again why do you want to do this?

Re: Same

smilingjohn — Thu, 23 Mar 2017 11:50:58 GMT

Hi Andrew

I have a month culumn as dimension , and i need to show month names horizontally , i do this by draginging the month column horizontally on the top header , which is not possible in Straight table .

Thats the region i want to achieve this in pivot table

Re: Same

vinieme12 — Thu, 23 Mar 2017 12:33:11 GMT

Yes you can make it look that way !

Try as below

Change it to a calculated dimension

Dimension1: =Leale1&chr(10)& Level2

Dimension2: =Level2