topic Re: Month minus previous month in QlikView

Month minus previous month

Mon, 08 Feb 2016 10:32:25 GMT

Hi,

first post so be gentle please

I have a data structure with numerous lines which I sum up against a calendar day/week/month as required..

Now in one specific chart I have the sums per month for all history.. I would like to have another column with the delta of X against month X-1 .

I have the previous month in as a value in the table structure, created with date((MonthStart)-1, 'MM/YYYY')

but how do I get the previous months numbers to display in the current months row..

thank you

Re: Month minus previous month

Mon, 08 Feb 2016 12:53:15 GMT

OK.. I have found the range sum and got this working...

next, I have only have 1 dimension..

how can I have 2 or 3 dimension??

Re: Month minus previous month

Mon, 08 Feb 2016 15:58:14 GMT

Try a master calender with a AsOfMonth field

f.e. a AsOfYear Table

Kalender:
LOAD * INLINE "

Year, AsOfYear, Periodtype
2000, 2000, Current
2001, 2001, Current
2001, 2000, Previous
2002, 2001, Previous

"

Re: Month minus previous month

Mon, 08 Feb 2016 16:04:20 GMT

Hi Chris,

Can you share an example QVW? I'm not sure I understand your requirements

Re: Month minus previous month

Mon, 08 Feb 2016 17:03:26 GMT

OK.

I have a chart, Dimension = YearMonth and expression = count(Amount)

next I wanted to add another expression to calculate the difference between each month and the month previous.

I think I can do this with the expression...

count(Amount) - RangeSum(Above(count(Amount),-1,1))

What I am struggling with is adding in a additional dimension (Category), as if I do this, the expression fails.

thank you

Re: Month minus previous month

Mon, 08 Feb 2016 17:50:31 GMT

Okay. Try this instead of your range expression

count(Amount)-Above(Count(Amount))

This will populate the cells when you add Category. You will then want to sort the chart so the expression works the way you need it. For example, if you need the change for each product over time, sort by product - text A->Z

Re: Month minus previous month

Tue, 09 Feb 2016 13:45:18 GMT

Thank you Caleb