Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

poupeinvista
New Contributor

Counter that does not count repeated terms

Hello!

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!

Tags (1)
3 Replies
shraddha_g
Honored Contributor III

Re: Counter that does not count repeated terms

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)

poupeinvista
New Contributor

Re: Counter that does not count repeated terms

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?
    2.     how many "coo" per user?
  1. How many different users have been registered?
  1. What "Amount" acquired by each "USER" in  time espace?

exemple chart data.JPG

shraddha_g
Honored Contributor III

Re: Counter that does not count repeated terms

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)