Qlik Community

New to Qlik Sense

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

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

invoice frequentie

Hi everybody,

I have a question about counting invoices. I am currently making an overview.

I actually have 2 questions:

1. some customers order 2x a day because they have forgotten something. This obscures the data. So I only want to count the first invoice per day per customer. How can I solve this?

2. Furthermore, I want to calculate the number of orders per week in the last 6 months (average) and offset this against the number of orders per week in the last month (also average). How can I calculate this? Thanks in advance!

Labels (1)
0 Replies