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

hi i am new here

hi...

i have expression that month over month calculation need upper arrow and down arrow

i am using expression is current month:------sum({<month={$(vcurrentmonth)}>}sales)

                                   previouse month:------sum({<month={$(vpreviousemonth)}>}sales)

need another expression for upper arrow and down arrow for variance in previous month and current month

1 Solution

Accepted Solutions
rubenmarin

Hi Saimohan, you can use this expression:

If(sum({<month={$(vcurrentmonth)}>}sales)>=sum({<month={$(vpreviousemonth)}>}sales),'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

In the Expressions tab, you need to select 'Image' as presentation.

View solution in original post

1 Reply
rubenmarin

Hi Saimohan, you can use this expression:

If(sum({<month={$(vcurrentmonth)}>}sales)>=sum({<month={$(vpreviousemonth)}>}sales),'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

In the Expressions tab, you need to select 'Image' as presentation.