topic How to show counts for only Null in Date column in set analysis...? in App Development

How to show counts for only Null in Date column in set analysis...?

dhasharadh — Fri, 05 Nov 2021 03:57:33 GMT

our report is based on the not nulls of Date, but to in order to give the comparison to users on nulls in Date, we want to show the diff status as KPIs exceptionally for nulls only.

in KPI we want to show the counts of IDs where Date is null and status is closed. in our date we have Date as null for different Status like for Active, Closed, ready to Closed.

we want to show the counts of those diff status for Nulls in Date.

tried below expressions in KPI its always giving 0, where as in table chart its working.. Any suggestions where am going wrong !

= Count({$< Status = 'Closed', Date-= {"= null() "} >} ID)

Count({$< Status = 'Closed', Date-= {"=Len(Date)>0 "} >} ID)

// Count({$< Status = 'Closed', Date-= {"=Date)>0 "} >} ID)

// Count({< Status = 'Closed', ID -= E({< Date = {"*"}>}) >} ID)

// if(len(Date) = 0,Count({< Status = 'Saved'>} ID))

Re: How to show counts for only Null in Date column in set analysis...?

AshutoshBhumkar — Fri, 05 Nov 2021 04:15:14 GMT

Hello,

Create a flag in the script which will identify the null records in Date. Like below.

If(Len(Date)=0,1,0) as NullDateFlag

And use the same flag in your set analysis.

E.g

Count({$< Status = {'Closed'}, NullDateFlag= {'1'} >} ID)

Thanks,
Ashutosh

Re: How to show counts for only Null in Date column in set analysis...?

dhasharadh — Sat, 06 Nov 2021 03:54:46 GMT

Thanks for the reply Ashutosh,

We have no access to script here..is there any way to do it in UI alone...as in order to create that flag in the script, we need to raise a request to other team who maintain qlik DM..

Re: How to show counts for only Null in Date column in set analysis...?

AshutoshBhumkar — Sat, 06 Nov 2021 03:57:08 GMT

Hello,

Could you please provide any sample data to work on ?

Thanks,

Ashutosh