Include NULL Values Handling in KPI charts in Qlik sense

[jaswanth222]

Hello Everyone,

I have an issue with the Set expression in KPI chart. i'm calculating the percentage in my expression i'm using Parent incident id for this column is having Null values i want to calculate the Null values. but while calculating the t column not considering. please find the below expression

Num(sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Status]={0},[Parent Incident ID]={'Null'}>}[Ticket Count])/sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Parent Incident ID]={'Null()'}>}[Ticket Count]),'##.##%')

please anyone can help me on this.

[BrunPierre]

Hi, I'd do this to assign null a selectable value and apply them in expressions.

If(Len(Trim([Parent Incident ID])), [Parent Incident ID], 'NULL') as [Parent Incident ID]

... [Parent Incident ID]={"NULL"} ...

[jaswanth222]

For data load editor not having access how can we do in expression.

[BrunPierre]

[Parent Incident ID]={"=IsNull([Parent Incident ID])"}

or

[Parent Incident ID]={"=Len(Trim([Parent Incident ID]))=0"}

[Syed_M0]

Mayebe this may work,

Num(sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Status]={0},[Parent Incident ID]={'$(=Null())'}>}[Ticket Count])/sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Parent Incident ID]={'$(=Null()'}>}[Ticket Count]),'##.##%')

[jaswanth222]

i have applied same expression and tried this is not working zero count showing but for that field has data.

[Syed_M0]

Try this

IF(Isnull(Field),Count(distinct Field))

[BrunPierre]

---

@BrunPierre wrote:

[Parent Incident ID]={"=IsNull([Parent Incident ID])"}

or

[Parent Incident ID]={"=Len(Trim([Parent Incident ID]))=0"}

---

@jaswanth222 have you tried these already?

[jaswanth222]

yes

[BrunPierre]

Try

[Parent Incident ID]= E({<[Parent Incident ID]={"*"}>})