Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

meetmrudul
Contributor II

Pivot Table with Dimensions and Measures and Inline

Hi All,

We have a Pivot table like -

Product Analysis.png

We have another similar table, which looks like -

Product Analysis_1.png

Now in first image, Product is a Dimension whereas, M1, M2, M3 are calculated measures.

In second table, we have Measure M1, M2, M3 as Inline load, and using pick match function we are calculating Avg, Sum and Diff.

Any idea regarding, how we can combine both the tables.

Regards,

MK

2 Replies
hf-group
Contributor III

Re: Pivot Table with Dimensions and Measures and Inline

Can you upload a example app?

And perhabs descripe a little bit more exact?

Are the Data connected?

What exact want you see in a combined table?

teiswamsler
Contributor II

Re: Pivot Table with Dimensions and Measures and Inline

Hi Mrudul K

Try mixing in the "Valuelist" funktion for Dim and Expr.
I dont fully understrand the requirement either.

ValueList - chart function ‒ Qlik Sense

/Teis