topic Re: Excel Pivot functionality in Qlikview in QlikView

Excel Pivot functionality in Qlikview

haribabugv — Fri, 15 Jul 2016 07:38:55 GMT

Excel Pivot functionality in Qlikview. When we click a cell in Excel pivot, a new sheet appears with whole data dump, but same action in Qlikview will result something different. So I want to replicate that excel pivot functionality in Qlikview. Can anyone help me here??

Re: Excel Pivot functionality in Qlikview

agni_gold — Fri, 15 Jul 2016 07:56:46 GMT

Can you share sample app here , in which you have tried something ? or please elaborate your question more

When we click a cell in Excel pivot, a new sheet appears with whole data dump means ?

Re: Excel Pivot functionality in Qlikview

haribabugv — Fri, 15 Jul 2016 08:34:29 GMT

Hello Agnivesh,

my Raw Data

PIVOT

After clicking Pivot cell 60, i get below output in PIVOT

Now in Qlikview i am not getting the same result as in Excel Pivot after double clikc

Re: Excel Pivot functionality in Qlikview

Anil_Babu_Samineni — Fri, 15 Jul 2016 08:43:32 GMT

Hari Babu,

In excel, Whatever you did you can't apply whole functionality in Qlikview. Because QV has some limited Access. But, you can achieve the Target in Qlik while whatever formula you did in Excel.

Or else please try to reply of Agnivesh

Re: Excel Pivot functionality in Qlikview

Anil_Babu_Samineni — Fri, 15 Jul 2016 09:00:32 GMT

in that, Can i know your Requirement

Updated : Attachment

Re: Excel Pivot functionality in Qlikview

haribabugv — Fri, 15 Jul 2016 09:29:45 GMT

Anil,

In your attachment, can we activate (pop up) second table only when we click any cell in 1st table?

is it possible in Qlikview?

Re: Excel Pivot functionality in Qlikview

Anil_Babu_Samineni — Fri, 15 Jul 2016 09:51:35 GMT

Pop up means what?

Re: Excel Pivot functionality in Qlikview

haribabugv — Fri, 15 Jul 2016 10:01:03 GMT

second table should be visible only when i click a cell in 1st table.

By default i should have only 1st table, when i click a cell in this 1st table, second table should be made visible

Re: Excel Pivot functionality in Qlikview

ThornOfCrowns — Fri, 15 Jul 2016 10:13:49 GMT

I have set up a spread sheet with your data and pivoted it. I do not get the filtering action when clicking on a row in the pivot table.

Re: Excel Pivot functionality in Qlikview

Anil_Babu_Samineni — Fri, 15 Jul 2016 10:20:51 GMT

As i know, Pivot table is not possible.

But we have one way to do this

Just create one text object and create one variable with Hide and Show option then put that text object on that cell with the transparency of 100%

Then try it should work

Good luck