Pivot Table in Qliksense

[arvind_patil]

Hi Experts,

How can I achieve below table in qliksense.

In That :

Product Is my Dimension

MonthYear is my Column

Exp1 and Exp2 is my measures .

Please  guide me.

Regards,

Arvind Patil

[Anonymous]

Yes, what we doing here is this:

On the load editor, calculate sum(Exp1) for CY and sum(Exp1) for PY

On the pivot table, calculate CY-PY as the measure.

[arvind_patil]

Hi Kaushik,

I am ebullient and happy to saw your answer. It has served my purpose.

Regards,

Arvind Patil

[Anonymous]

This is a sample. Change the condition to reflect month(today()) and CY/PY instead of Jan/Feb.

[luismadriz]

Hi,

Sorry, I haven't seen one but maybe just creating 2 pivots could help? at least both pivots will react similarly

I tried adding Totals and testing secondarydimensionality() so to show only for Totals and not for Months but couldn't get rid of the nulls

I hope it helps

Cheers

Luis

[luismadriz]

Nice!!!

Qlik and this community never cease to amaze me!

Cheers

Luis