Discussion board where members can get started with Qlik Sense.
I'm Trying to Generate a Function That Counts HOW many user registrations have occurred in a certain Establishment, yet ONE SAME User Appears on Different Dates. I CAN NOT COUNT Repeated users, (WITH SAME ID number).
Thanks for the collaboration!
How do you want to show the data?
Do you want to count Repeated Users or not?
If you want to count then Count(UserID)
Else for non repetitive Count(Distinct UserID)
Thank you for your attention!
I'm a beginner in this tool and I'd like to ask for help.
using the table above as a reference, I would like to extract this information and design it in the graph, what would the program line be like?
1. sum of the value linked to the coo used by the user?
Not so sure about it.. but Dimensions can be UserID and coo and Measure can be sum(Value)
2. how many "coo" per user?
Dimension can be UserID and Measure can be Count(Distinct coo)
3. How many different users have been registered?
Dimension can be Point of Sale and Measure can be Count(Distinct UserID)
4. What "Amount" acquired by each "USER" in time espace?
not so sure about it.. but Dimensions can be Date, Time and UserID and Measure can be Sum(Value)