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: 
Falkvw
Contributor
Contributor

Expression counting users having events following each other

Hi,

 

I am new to Qliksense and the syntax and completely stuck in the following task... I have two tables.

One is users and one is user actions with timestamp.

Now I want to count the users (id) of having the action with action="trial" and having the action action="purchase" with a later timestamp than the the "trial" one. So I want to count the users with a successful trial action as the had a later purchase.

These are the tables

Firefox_Screenshot_2020-11-03T06-06-08.444Z.png

Firefox_Screenshot_2020-11-03T06-05-58.644Z.png

I appreciate every help.

Thank you very much

Labels (2)
2 Replies
MayilVahanan

HI @Falkvw 

Try like below

Count({<action={'trial'}>} distinct Id)

To get the trial action user information

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Falkvw
Contributor
Contributor
Author

Hi thank you

i know how to count users having an action with trial. But what i want is count users that have an action with trial AND an action with „purchase“ with a later timestamp than the trial. Is that possible?