Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
elaineng
Contributor III
Contributor III

Count buyer no of 1st channel & source within date range

I have two tables:
1) Buyer (buyerid, name, age,...)

2) Buyer activity (buyer activityid, buyerid, date, channel, source, etc)

I need to create a table which count the buyer no for 1st channel and source within the buyer activity date range selected by user.

Labels (2)
1 Reply
elaineng
Contributor III
Contributor III
Author

I tried:
dimension: channel 
Exp: = count(IF(BuyerActivity_createdon = Aggr(Min(BuyerActivity_createdon), buyerid), buyerid))

It will give me the result I want

elaineng_4-1673516586285.png

 

elaineng_1-1673516386989.png


But if I selected date, it is not providing the correct result. Eg: 02/01/2023 7:12:33 PM onwards

elaineng_5-1673516636735.png

 

elaineng_3-1673516475273.png


Landing page should count as 1 as it is the earliest record.