topic Re: create pivot tables automatically qlikview in QlikView

create pivot tables automatically qlikview

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

Hi.

I have an excel with several tables and they asked me to recreate something similar.

Each table has an "Lote de Inspección" with its respective analyzes.

I managed to recreate with a pivot table but within the table are all the inspection lots and the objective is to have several tables. Is it possible to create pivot tables automatically for each "Lote de Inspección"?

Greetings.

Re: create pivot tables automatically qlikview

juraj_misina — Wed, 15 Aug 2018 20:01:49 GMT

Hi,

I don't think you can do this automatically, but u can easily create copies and adjust those copies with set analysis on the [Lote de Inspección] field. But, my first question to end users would be, do they really need so many separate tables? Can't they do with 1 and select particular Lote de Inspección from a list box? Or maybe two (with alternate states) tables if they want to compare different Lote de Inspección?

Hope this helps.

Juraj