Discussion Board for collaboration related to QlikView App Development.
I want to show trend Month wise, but my logic is to show Last to last month value in current value if the day is less than 7.
I am able to do it in text box but not in Line Chart
sum Sales for Jun is 200
and Current Month is August date 07/08/2015
so the sum of sales for Aug month should be 200
Hope you understand and provide me with great solution.
Hi Kavita, hope this expression helps you:
Above(Sum(Sales))) // This gets your previous loaded month (for 07/08 will get Jul)
Above( sum(Sales),2) gave me the values for June This is for below 7.
Also I want for Above 7 or equal to 7 it should give me the values for Jun