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

[dhasharadh]

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))

[AshutoshBhumkar · Accepted solution]

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

[dhasharadh]

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..

[AshutoshBhumkar]

Hello,

Could you please provide any sample data to work on ?

Thanks,

Ashutosh