topic Pivot table related query in QlikView

Pivot table related query

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

Hi Experts

my dashboard o/p like this in pivot table is below

After export to excel getting the below format

Type	Non Deal Management	Non Deal Management	Non Deal Management	Non Deal Management	Non Deal Management	Conference	Conference	Conference	Conference
Id	1X1	2X1	3X1	Conference	Group Meeting	1X1	2X1	3X1	Group Meeting

After export the excel ,i am expacted o/p like this.

How to get.......

Thanks

shiveshsingh — Tue, 20 Feb 2018 05:57:36 GMT

Like below

Conference

Non Deal Management

Type

1X1 2X1 3X1 Group Meeting

1X1 2X1 3X1 Conference Group Meeting

I tried, got above result in table box

ramasaisaksoft — Tue, 20 Feb 2018 09:31:15 GMT

Hi Nani,

it won't happens like you mentioned.when i tried to export the pivot table i got properly only.

any way my suggestion is just create one more pivot table and export that pivot table with 2 modes

export both the types of Pivot table and verify your result.

Example:-