topic Re: Multi Pivot table into one in QlikView

Multi Pivot table into one

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

Hai,

I have created multi pivot table in one dashboards...when i convert this dashboard into excel,it shows each one(separately- asusual)..

but my requirement is..when i cnvt this into excel..it should show like in one chart..(like one n next one )....

i have tried the container too..but its not wrkng..

how can i link the multi pivot table in one pivot table...(each table having different data-it cant be change)..but i need in one pivot table wid same data n titles.

Hope u can undrstand this question..

Re: Multi Pivot table into one

Gysbert_Wassenaar — Fri, 30 Dec 2016 09:31:36 GMT

You can't export multiple pivot tables into one pivot table.

Re: Multi Pivot table into one

giakoum — Fri, 30 Dec 2016 09:44:07 GMT

Why don't you create the multi pivot into one in QlikView (maybe as hidden) and then export it to excel?

Re: Multi Pivot table into one

Anil_Babu_Samineni — Fri, 30 Dec 2016 09:59:52 GMT

I would go with Gysbert, How do you hide. Do we have any clues on that?

But, Thread owner is intend to export all chart into one object. As i know that not possible

And, If you really want same thing then you may create single object by using ValueList. But, Front end performance is not good at all. It kills the RAM too.

Re: Multi Pivot table into one

Anonymous — Fri, 30 Dec 2016 10:29:54 GMT

Thanks to all..By using Pick function, it is possible to create?? I dnt get any idea..bt thz iz my req.

Re: Multi Pivot table into one

Anil_Babu_Samineni — Fri, 30 Dec 2016 10:37:14 GMT

Can you describe short way as per BRD for me

Update: You can achieve like below, But it kills performance Learning from stalwar1

Dimension

=Pick(Dim, 'Sum Sales', 'Avg Sales','Count Sales','Philips Data','Nokia Data')

Expression

Pick(Dim, Num(Sum(Sales), '#,##0'), Num(Avg(Sales)/1000, '##%'), Num(Count(TOTAL Sales), '#,##0'), Num(Sum({<Product = {'Philips'}>}Sales),'#,##0'), Num(Sum({<Product = {'Nokia'}>}Sales),'#,##0'))

Re: Multi Pivot table into one

sathishkumar_go — Fri, 30 Dec 2016 11:27:22 GMT

I think you need to use the macro. Please explain your requirement in more detail.

-Sathish

Re: Multi Pivot table into one

Anonymous — Mon, 02 Jan 2017 06:30:53 GMT

Hai,

I found the solution for that...we can use the pick function to create multi pivot table into one table..

Pick(n,exp1,exp2).by using this i have done..before dt we should the load line.

Thanks