This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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
Sum(Aggr(RangeSum(Above(Count(DISTINCT Key), 0, RowNo())), Key, (submissiondate, (NUMERIC))))
View solution in original post
this is exp I am using in text object
I have attached the qvf
I am still trying to figure out how you are getting to your output... this is how your raw data look like... can you explain us the logic behind the output needed
Logic is for the current month count of Key and also the same keys if it is present in the previous months
for 01-10-2018 (01CA+01TX+02CA and same ids if present in previous months is 01TX) =4
for 01-09-2018 (count of ids 01PA+01TX+02TX ) and no previous month so the overall count is 3