Not sure to be capable to create this table in Qlik

[sdavinblanc]

Hello,

I'm new with Qlik and i'm trying to create the Excel table you can see on the attached file. 

Column A is filter with some "Destination".

Column B is result for my month reference (YYYYMM)

Column C is result for one year ago (YYYYMM-1)

Column D  is result for three years ago (YYYYMM-3)

Column E is calculating the variation between month reference and one year ago (Col A- Col C/Col C)

Column F is calculating the variation between month reference and three year ago (Col A- Col D/Col D).

I've tried to do it with two different object "Pivot Table" and "P&L Pivot" with no success. 

Is there a way to do that easily ? 

Hope my explanations are clear ! Thanks for your help

[Oleg_Troyansky · Accepted solution]

Hi there,

This looks like a simple Table, or a Straight Table. Your first column, the Destination, is the Dimension, and your other 5 columns are Measures. Formulate the expression for each Measure, and voila!

For your last two columns, you can use precalculated results from the first three columns. You can reference them either by name or by number. For example:

([This Month] - [This Month PY] ) / [This Month PY]

or

(Column(2) - Column(3)) / Column(3)

Your first Measure is Column(2) - the Dimensions are also counted as columns.

Cheers,

Oleg Troyansky

P.S. Join my Qlik Expert Class in Vienna to learn advanced Qlik methodologies!

[sdavinblanc]

Hi Oleg

Thanks for your reply, i will try this and let you know 😉

[sdavinblanc]

Hi Oleg,

I have succeded

Thank you for your help