Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
jerry_ile
Contributor III
Contributor III

How do I Aggr orders by unique customers

Hi,

I am attempting to create a table that gives a topline grouping of customers by the amount of orders they have created, I can't do this in the load script as need to be able to change time periods 

It should look like this 

Frequency (Orders) Count(distinct [Order ID]) count(distinct [Customer ID])
14306343063
2161168058
380912697
442721068
52600520
>58393731

 

I tried 

aggr(if(count(distinct [Order ID])<=5, Text(count(distinct [Order ID])),'>5'), [Customer ID])

aggr(if(count(distinct [Order ID])<=5, Text(count(distinct [Order ID])),'>5'), [Customer ID]) Count(distinct [Order ID]) count(distinct [Customer ID])
                                          82,535                                                 56,137

 

but it shows as a blank, if I add customer ID as a dimension I can see that the aggr is correctly grouping the customers, but just can't get it to show in the table ?

 

 

 

10 Replies
Lauri
Specialist
Specialist

It'd be worth upgrading to June 2019 just to see. If no luck there, go to support:
https://qliksupport.force.com/qs_home_page