Pivot Table with Dimensions and Measures and Inline

[Anonymous]

Hi All,

We have a Pivot table like -

We have another similar table, which looks like -

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

[Ralf_Heukäufer]

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]

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