topic Combine Pivot Data/Results in Another Diagram in App Development

Combine Pivot Data/Results in Another Diagram

Anonymous — Mon, 17 Oct 2016 06:23:24 GMT

Dear All,

I recently started to work with Qlik Sense Desktop. Now I wonder if there is any chance to combine the data/results of different Qlik pivot tables in another diagram.

In one pivot I calculate the average usage of a material per month; in another table I calculate the overal availability of a material. Now I would like to take both results per material and month and join those values in another diagram and calculate with those values.

Any support appreciated.

Thanks and regards,

Philipp

Re: Combine Pivot Data/Results in Another Diagram

Oleg_Troyansky — Mon, 17 Oct 2016 18:16:49 GMT

Hi Philipp,

Objects are completely independent in Qlik Sense. So, you can't literally reference the results of one object in another object.

You can create the other object in a way that repeats the same calculations that were made in the first object. It's easy to do if you use Master Items - Master Dimensions and Measures in both charts.

hope it helps,

Oleg Troyansky

Learn advanced techniques for QlikView and Qlik Sense in my new book QlikView Your Business.