Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show variation to previous month in a Line Graph with month dimension

Hi,

I have a Line graph with monthly evolution sales (blue line) showing last year same month sales (red).

I want to show as a new expression sales of previous month (for the range of months in the selection).

QV_SalesEvolution01_Eng.png

My expressions are:

-USD =Sum(dolares)

-USD (-1 Year) =Sum({$<year={$(=Max(year)-1)}>}dolares)

-USD (-1 Month) =Sum({$<month={$(=Max(month)-1)}>}dolares)

In the graph I get a green point, that I want to be a line and I want to shift 1 month forward.

Any suggestions?


Thanks in advance.

Javier

0 Replies