Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.