topic Re: Months difference in pivot in QlikView

Months difference in pivot

Thu, 23 Apr 2015 10:57:54 GMT

Hi guys!

I guess this is a simple question, but still cant find a solution.

I have a pivot like:

BG	Month1	Month2	Month3	Month4	Month5	Month6	Month7	Month8
BG1	1	2	3	4	5	6	7	8
BG2	1	2	3	4	5	6	7	8
BG3	1	2	3	4	5	6	7	8
BG4	1	2	3	4	5	6	7	8
BG5	1	2	3	4	5	6	7	8
BG6	1	2	3	4	5	6	7	8
BG7	1	2	3	4	5	6	7	8

Need to create one more column with the expr to find difference between months like : Month2-Month1, Month3-Month2, etc.

Any ideas?

Re: Months difference in pivot

Gysbert_Wassenaar — Thu, 23 Apr 2015 11:22:18 GMT

If the MonthX columns are 8 different expressions you can add 7 more expressions using the column names: [Month2]-[Month1]. If you have a Month dimension pivotted horizontally and one expression you can try the before() function:

first expression: count(Value)

second expression: count(Value)-before(count(Value))

Re: Months difference in pivot

maxgro — Thu, 23 Apr 2015 11:22:22 GMT

if Month is a dimension try with before(your_month_expression) ot get the "left" month

Re: Months difference in pivot

PrashantSangle — Thu, 23 Apr 2015 11:27:19 GMT

Hi,

But what if there is two dimension and one expression

for example in above

Dimension 1: Month

Dimension 2: BG

Expression : Sum(Sales)

In that case how we can find difference between two month.

Reason behind asking is I also have similar type of query.

Regards,