Discussion board for questions about the Qlik Community Platform as well as general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!
I have sample data as below
submitdate,count of product id
Logic is for check the possible (ID &Location) with previous months
I am able to achieve this in text object but I am not getting how to achieve in the chart with dimension as date .
Shruthi B K
ya it will be 5 for 01-10-2018, 4 for 01-09-2018 and 1 for 01-08-2018
Sum(Aggr(RangeSum(Above(Count(DISTINCT Key), 0, RowNo())), Key, (submissiondate, (NUMERIC))))
View solution in original post