Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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

Re: Calculate % of occurrence with delays > 10 days

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
Highlighted
Specialist
Specialist

Re: Calculate % of occurrence with delays > 10 days

try this in straight table :

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

and change the Number format  to "show in Percent"

Re: Calculate % of occurrence with delays > 10 days

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

Highlighted
Partner
Partner

Re: Calculate % of occurrence with delays > 10 days

thanks, both solutions work fine!