Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Month Over Month Sales

I've tried variations of all the formulas I've found on here for month over month, and so far none of it works.  I need to see sales month over month like this, MonthYear, that month's sales, then the previous month's sales in the 3rd column.  Please somebody help me.

17 Replies
OmarBenSalem

your first expression is :

sum(Sales)

add, in the 3rd column : above(sum(Sales)

and see what happens

Anonymous
Not applicable
Author

3rd column as: !

peek(sum(Sales))

OmarBenSalem

Peek is a script function; you can't use in the front end; above will replace it in the front end.

Peek can be used for the same purpose as follow, but within the SCRIPT:

QlikView Peek Function

Anonymous
Not applicable
Author

I'm just a user, not a developer.  I do not have access to the back end, so I can't create variables, either.  I will try the 1st option, though.

Anonymous
Not applicable
Author

"Above" worked.  If I reverse the sort to show most recent month first, do I use "below"?

Anonymous
Not applicable
Author

"Above" worked.  Trying "Below" for a reverse sort.

Jodi

Anonymous
Not applicable
Author

Below only works so long as I have no filters.  I have an if/then saying if the month below was 0 or null, do this.  Let's say the changeover happened in January 2018.  As soon as I filter on just 2018, there is no below and January doesn't calculate correctly.  Please, I need a formula that will bring me sales data for the previous MonthYear in each line item.

Again , I cannot create variables.

zebhashmi
Specialist
Specialist

Sum({$<Date = {$(=addmonths(Date, -1))}>}Sales)

Anonymous
Not applicable
Author

I’m sorry, it’s not working. This is the formula I adapted from your response:

sum({$}GROSS_ACTS_REACTS_UPGRADES)

I’m getting all zeros in that column.