Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How calculate how many user has done the same number of order.

Hi all,

i have a problem calculating the number of user that have done an order.

How i can calculate the next scenario?

USER,   NUMBER ODER

a               10

b               4

c               3

d               10

e               3

I know that there are two user that have done 10 orders, two user that have done 3 orders and one that has done 4 orders.

USER      NUMBER ORDER

2               10

2               3

1               4

The number od order is calculated with count(id_order) but how i can calculate the user?

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: How calculate how many user has done the same number of order.

Just create the Chart with below Dimension &  expression:

Chart Type: Any

Dimension: OrderNumber

Expression: Count(USER)

1 Reply
Not applicable

Re: How calculate how many user has done the same number of order.

Just create the Chart with below Dimension &  expression:

Chart Type: Any

Dimension: OrderNumber

Expression: Count(USER)

Community Browser