Skip to main content
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?