topic Re: Use Pivot Table as Datasource in Qlikview in QlikView

Use Pivot Table as Datasource in Qlikview

Wed, 22 Apr 2015 07:49:49 GMT

Hello to everyone !

I am back again with another question to you. In fact, I have been working yesterday on pivot tables. However, I don't know if it is possible to use pivot tables as datasource in order to use it in other charts and objects.

Thank you and have a good day !

Re: Use Pivot Table as Datasource in Qlikview

Gysbert_Wassenaar — Wed, 22 Apr 2015 08:01:43 GMT

No, all charts in qlikview use the internal in-memory database as data source. Charts cannot reference data that is calculated in other charts. It is possible to put the chart expressions in variables and use the variable in several charts. That way it is possible to reuse the expressions in more than one object.

Re: Use Pivot Table as Datasource in Qlikview

Wed, 22 Apr 2015 08:04:41 GMT

Thank you,

Then how can tables obtained from pivot tables be used in qlikview?

Re: Use Pivot Table as Datasource in Qlikview

Anonymous — Wed, 22 Apr 2015 08:07:22 GMT

In order to user your pivot chart or any data source you will need to bring in QlikView in-memory data model. You may need to enable the transformation while loading and then you have to plot again in QlikView UI.

Best,

Shubham

Re: Use Pivot Table as Datasource in Qlikview

Wed, 22 Apr 2015 08:12:52 GMT

What do you mean by enabling the transformation while loading?

Re: Use Pivot Table as Datasource in Qlikview

Anonymous — Fri, 24 Apr 2015 15:58:52 GMT

If you are loading any crosstable or xls where you need only particulare data in particular fashion, you'll need to go for transformation step where you can edit or delete the rows and colums and many more.