topic Re: Add column for %change in QlikView

Add column for %change

Alma1234 — Wed, 21 Mar 2018 13:50:20 GMT

Hi there,

I need to add to the following chart 2 columns:

1) Feb-18 - Dec-17 Change in Sales

2) Change % (between Feb 18 and Dec 17)

Would like to get ideas.

Thanks,

Re: Add column for %change

YoussefBelloum — Wed, 21 Mar 2018 13:52:44 GMT

Hi,

is it a pivot table on the Image ?

Re: Add column for %change

eliran — Wed, 21 Mar 2018 14:01:54 GMT

Hi Limor,

How are you?

If it's indeed a pivot, you can't do it straight forward.. you'll have to add special values into the period dimension, and alter your expression to match the column.

Maybe try keeping it simple, add specific expressions for selected columns, and then add the two more columns, delta between the selected periods, and the %change.

Hope it helps,

Eliran.

Re: Add column for %change

Alma1234 — Thu, 22 Mar 2018 13:22:37 GMT

Yes its a pivot

Re: Add column for %change

Alma1234 — Thu, 22 Mar 2018 13:24:14 GMT

Hi Eliran,

Thanks for the reply.

I tried but since this value in the calendar doesn't connect to the other tables,

it creates an incorrect values.

Best Regards,