Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Month-over-Month expression in straight table

Hello. I am trying to create an expression that looks at month-over-month changes. This would be in a straight table. The month dimension of the chart is named [Ordered Month].

Here is the current period expression:

SUM([Running Day Count])/COUNT([Magnet Order ID])

I have tried all sorts of set notation. I think I'm on the right track, because this expression quasi-works:

SUM({<[Ordered Month] = {May}>} [Running Day Count])/(COUNT({<[Ordered Month] = {May}>} [Magnet Order ID]))

Obviously, I am hard-coding May in the expression formula above. This works, but only for the row in my table for May. I want to generalize this formula to be the previous month for each month value in the dimension. Once I do that, I'll subtract this good formula from the basic sum()/count() expression to get the month-over-month delta.

Unfortunately, I don't have an easy way to scrub out senstive data in order to post the .QVW here. I appreciate any help you can offer!

Thanks!

Message was edited by: sdseasd1 (formatting code chunks appropriately)

1 Solution

Accepted Solutions
MVP
MVP

Re: Month-over-Month expression in straight table

Instead of the set expression, use

=above(column(1))

to retrieve the value for the previous month that is calculated in column(1)

[Or repeat your expression:

=above( YourExpressionComesHere )

]

2 Replies
MVP
MVP

Re: Month-over-Month expression in straight table

Instead of the set expression, use

=above(column(1))

to retrieve the value for the previous month that is calculated in column(1)

[Or repeat your expression:

=above( YourExpressionComesHere )

]

Not applicable

Re: Month-over-Month expression in straight table

Wow... I was going in the completely wrong direction. Thank you very much for the quick response.

Community Browser