Count greater than & set in relation to

[AndrejLinde]

Hello everyone,

I'm new to QlikSense and have a problem, maybe someone can help me:
I have a list of orders includng the days they're pending.

Now I only want to count the orders with pending days >= 8days.

Next I want to know the percentage of the pendingdays>=8days off the total orders.

Example:
total orders: 700

>=8days: 109

Thank you for your kind help!

[Edvin]

Hello, Andrej,

=Count({<[Pending days]={'(=>8)'}>} [Order]) - this counting the orders with pending days greater than 8 days.

=Count({<[Pending days]={'(=>8)'}>} [Order])/Count([Order]) or

=Count({<[Pending days]={'(=>8)'}>} [Order])/Count(TOTAL [Order])

[AndrejLinde]

Hi Edvin,

Thanks for the quick reply!

If I get that right my function should look like this:

=Count({<[PENDING_DAYS]={'(=>0)'}>}[Sheet1.Service_order]) - for jsut counting the orders that are 8days and older.

But this gives me a result of 0.

What am I doing wrong?

[Edvin · Accepted solution]

Um, yeah, sorry. I just edited my reply, you need () brackets
=Count({<PENDING_DAYS={'(>=8)'}>} [Sheet1.Service_order])

[AndrejLinde]

 thank you so much! 

Its working!!
The next function for showing the percentage is also fine. Just had to add "*100" at the end so it gives me a percentage.

Thanky for your quick help!