Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
yashcena
Contributor III
Contributor III

Need to Get Distinct Account_Created Dates

Hi,

I'm working with web traffic data where I have pageviews of different pages of a website. Some of the pages have UserID in the URL while some don't.

The data looks like this:

Web_Visit_DateWebPageUserIDUser_Account_CreatedPageViews
2/2/2021webpage/createprofile  25
2/6/2021webpage/createprofile  12
2/12/2021webpage/myprofile/u99992/12/202121
2/12/2021webpage/myprofile/u34342/12/202121
2/12/2021webpage/myprofile/u47472/6/20211
2/12/2021webpage/createprofile  15
2/13/2021webpage/myapps/u34342/12/202111
2/13/2021webpage/myapps/u99992/12/20213
2/13/2021webpage/myapps/u47472/6/20212
2/13/2021webpage/myprofile/u55552/13/202119
2/13/2021webpage/myapps/u55552/13/202110
2/13/2021webpage/myprofile/u81812/12/202141
2/13/2021webpage/createprofile  75
2/14/2021webpage/newapp/u34342/12/20215
2/14/2021webpage/newapp/u47472/6/202112
2/14/2021webpage/newapp/u55552/13/20217
2/14/2021webpage/newapp/u81812/12/202141
2/14/2021webpage/createprofile  23
2/15/2021webpage/createprofile  9
2/16/2021webpage/myprofile/u19192/15/202121
2/16/2021webpage/myapps/u19192/15/202111
2/16/2021webpage/newapp/u19192/15/20215

 

I want to create a view where I can see the total pageviews of the 'webpage/createprofile' by date and the total number of accounts created on that date.

Desired View: Create Profile Visits vs. Accounts Created
DateCreate Profile PageviewsNo. of Accounts Created
2/2/2021250
2/6/2021121
2/12/2021153
2/13/2021751
2/14/2021230
2/15/202191

 

I'm not able to figure out how to get the number of accounts created for each date because every user has visited one or the other page on multiple days and taking a distinct count of 'User_Account_Created' column isn't giving the correct number of accounts created.

I'm thinking I'll need to something at script level but not sure.

Any help would be greatly appreciated.

1 Reply
JuanGerardo
Partner
Partner

If you use the condition that the User_Account_Created is equal to Web_Visit_Date, you can have those expressions with set analysis:

Count({<Web_Visit_Date={"=Web_Visit_Date=User_Account_Created"}>} Distinct UserID)

JG