Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
davdiste
Partner - Creator
Partner - Creator

Calculate % of occurrence with delays > 10 days

Hello,

I'm trying to define an expression for calculate the % of occurrence with delays > of 10 days.

A example of the dataset is enclosed below.

  

datedelay_days
01/10/20162
02/10/20163
03/10/20164
04/10/201615
05/10/201620
06/10/20162
07/10/201615
08/10/20169
09/10/201676
10/10/201643

The desired value of the indicator is 50%

In your opinion what is the best way to define the expression?

Thanks

Davide

1 Solution

Accepted Solutions
sunny_talwar

If this is done in a text box object, I don't think denominator needs a total here:

Count({<[delay_days]={">10"}>} delay_days)/Count(delay_days)

View solution in original post

3 Replies
Anonymous
Not applicable

try this in straight table :

count({<[delay_days]={">10"}>}delay_days) / count(TOTAL delay_days)

and change the Number format  to "show in Percent"

sunny_talwar

If this is done in a text box object, I don't think denominator needs a total here:

Count({<[delay_days]={">10"}>} delay_days)/Count(delay_days)

davdiste
Partner - Creator
Partner - Creator
Author

thanks, both solutions work fine!