Measuring variation between columns

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have this Pivot Table, with 2 dimensions. One dimension is Product Id, and the 2nd one is Week, that I move it as an horizontal dimension. An the metric is Sales. So here I can quickly check sales per Product Week over Week and for example find out that Product 1 last week sales drooped a lot.

My questions are

1-How can I make an expression to measure variation over previous column?, instead of showing the sales value of the week.

2-How can I sort 1st dimension. Product Id, considering total sales Desc and not only last column.

Thanks in advance for you help!

Re: Measuring variation between columns

Gysbert_Wassenaar — Wed, 30 Mar 2016 07:21:22 GMT

1. Use something like sum(Sales)/before(sum(Sales))

2. Try sorting by expression. Perhaps =sum(Total <[Product Id]>Sales)

topic Re: Measuring variation between columns in QlikView

Measuring variation between columns

Re: Measuring variation between columns