Hi Sunny - I tried above... Performance of my DB is poor.. After adding the "RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))" , am just stuck with the chart to get Refreshed.. It shows below Refresh icon and it is still at this screen for almost 15 mins... I have around 1M rows.. Any other better idea to improve performance?
Hello Sunny. I'll be really glad, if you help me with the same case.) I have Table containing two column "date" and "sale".and I try to find out how i can get cumulative sum in each month i have. I need table like this. Please, help me =(:
So, the expression 1 is dependent on your chart sorting which needs to be first by MonthYear and second by date in ascending order
expression 2 is dependent on sort in the script... for this to work, date needs to be sorted in ascending order within the script. In this case it was, so it worked.
expression 3 is only doable in QlikView 12 or above as it was introduced after with QV 12.... you can read more about it here The sortable Aggr function is finally here!, but the idea is that you can specify the sorting with aggr function and not just take the sorting from the load order.