topic Re: Year comparison for expressions in QlikView

Year comparison for expressions

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

Hello,

I have a pivot table with many expressions that are vertically arranged and a month dimension. I want to make a comparison with the same month last year, plus a quarter sum and I don't know how to do this for all expressions.

Now I have:

-	Jan	Feb	Mar	Apr
Expression 1
Expression 2
Expression 3
Expression 4
Expression 5

And I want to obtain:

Jan 2016

Jan 2015

Jan %

Feb 2016

Feb 2015

Feb %

Mar 2016

Mar 2015

Mar %

Q1 2016

Q1 2015

Q1 %

Expression 1

Expression 2

Expression 3

Expression 4

Expression 5

Any ideas?

Thank you!

Re: Year comparison for expressions

Mon, 31 Oct 2016 22:19:22 GMT

You can user alternate states for your situation.

Easy for me to say , can you upload qvw?

Re: Year comparison for expressions

simonagheo — Wed, 02 Nov 2016 09:06:43 GMT

I made a simplified sample with just one table and some expressions. Actually there are many other expressions and columns. Can you help me to compare every epression with the same expression last year?

Re: Year comparison for expressions

Fri, 11 Nov 2016 07:05:03 GMT

I have created seperate calendar date data in excel spreadsheet which has two years (2015&2016) data.

Attached qvw & excel.

I have left months format as was uploaded.