Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
AnkitMadhukar
Creator
Creator

Showing Previous month Sales

Hi Everyone,

Is there way to show previous month sales and this month sales in a straight table , without using the below() function

The table Structure I am trying to create is and the used measure 

Year MonthRevenue --> Sum(amount)Revenue Previous Month --> below(sum(amount))
2020-041000800
2020-03800500
2020-02500-




Is there way to get to this result without the below function. 
The reason is that sorting is not preserved in Qlik Sense Alert (SaaS ) and the below results get changed because of that.


On another note , is there  a way to sort the alert columns in Qlik SaaS ( I was not able to find that option)

Thanks,
Ankit 

Labels (1)
0 Replies