Show 100% in KPI instead of dash

[Ironduke]

I want to calculate  a percentage how many tasks the team are completing each month, which I can do but I also want to show 100% instead of a dash even if they don’t have any tasks that month.

Can that be done, if so how do I add it into the set analysis?

Example

Jan had 10 tasks completed 9 in sla,  qliksense shows 90%.

Feb had 6 tasks completed 3 in sla,  qliksense shows 50%.

Mar had 0 tasks completed 0 qliksense shows – (would like it to show 100% instead)

[JordyWegman · Accepted solution]

Hi,

You can put an if() around it.

If (  Count( Tasks)  = 0,

1,

{Your formula}

)

Jordy 

Climber