Qlik Community

Ask a Question

Community Corner

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!

Announcements
2021 Gartner® Magic Quadrant™ for Data Integration Tools. See why Qlik was recognized yet again GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
shruthibk
Creator
Creator

set analysis Possible combination counts

Hi All,

I have sample data as below 

ID,Location,market,submitdate

01,CA,America,'2018-10-01',
01,TX,America,'2018-10-01',
02,CA,America,'2018-10-01'
01,PA,America,'2018-09-01',
02,TX,America,'2018-09-01',
01,TX,America,'2018-09-01'
01,CA,America,'2018-08-01'

 

expected output

submitdate,count of product id

2018-10-01,        5

2018-09-01,         4

2018-08-01,         1

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 .

Thanks,

Shruthi B K

11 Replies
shruthibk
Creator
Creator
Author

ya it will be 5 for 01-10-2018, 4 for 01-09-2018 and 1 for 01-08-2018

sunny_talwar

Try this

Sum(Aggr(RangeSum(Above(Count(DISTINCT Key), 0, RowNo())), Key, (submissiondate, (NUMERIC))))

image.png

View solution in original post