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 Month | Revenue --> Sum(amount) | Revenue Previous Month --> below(sum(amount)) |
2020-04 | 1000 | 800 |
2020-03 | 800 | 500 |
2020-02 | 500 | - |
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