Discussion board where members can get started with Qlik Sense.
Can any one please help me on below requirement.
I have a bar chart with YTD amount in first bar chart like below.
I have used the below expression
From these 2018 ytd bar chart I have to show 2018 each month amount like 2nd bar chart
For this please help me to change the above expression like 2018
Current Month amount-Previous month amount for getting only that month amount instead of ytd amount.
Thanks in advance
Go to Solution.
you could change it in:
if( num(your_month_dimension) = 1, column(1), column(1) - above(column(1)) )
Why are making complicatiuons,
simple use month as dimension and use expression as
The Bar chart will show monthly amounts in 2018 only
let's try as below:
column(1) - above(column(1))
Thanks for your reply.
The expression is working for all the months except Jan.
For Jan need to keep the actual amount from feb the above calculation need to apply.
Please help me on this.