Tables with Nulls and Without nulls

[Anonymous]

Hi

I am trying to separate a table into 2 tables - one with Nulls in SLA Fields  ( SLA_TP99 and SLA_FCI ) AND one without Nulls in SLA Fields ( SLA_TP99 and SLA_FCI ) .. and their corresponding record counts in the captions of the tables .. I tried using SLA_FCI={'*'} and SLA_TP99 ={'*'} in all my expressions but it does not seem to work , can someone please take a look .. attached is my application.

Please note I have alternate states in my app

Thank you,

[ramoncova06]

have you removed the suppress missing from the presentation tab ?

have you used nullcount ?

this one will identify none nulls

only({<SLA_FCI ={"=nullcount(SLA_FCI )=0"} ,

    ServiceTimeSeries.Date={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}(SLA_FCI/100))

and this will identify nulls

only({<SLA_FCI ={"=nullcount(SLA_FCI )>0"} ,

   ServiceTimeSeries.Date={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}(SLA_FCI/100))

[Anonymous]

Hi ..

Yes I unchecked suppress missing,

I am able to get the table where both fields have a value , the problem I am facing is when I need to check either one is blank ... so basically need to get the OR condition in set analysis ,adding the below for all my expressions worked for getting the table with Non Null values ,

SLA_TP99={'*'}, SLA_FCI={'*'}

As soon as I include SLA_FCI ={"=nullcount(SLA_FCI )>0"} ,SLA_TP99 ={"=nullcount(SLA_TP99 )>0"}  in my expressions the table becomes blank.

Thanks

[sunny_talwar]

Not sure what happens if one is null and the other is not. Check the attached and make modifications accordingly.

[Anonymous]

Thanks Sunny .. that is the problem for which I am trying to find a solution , I need to show values with Not Null values in those 2 fields in One table and With either one or Both being nulls in another table.

[sunny_talwar]

So the first table only includes stuff where both are not null and second table includes either one is null or the other is null?

[sunny_talwar]

Seems to be working. 1627 without nulls and 274 with nulls based on your current filters (Total 1901)

[Anonymous]

Thank you!

[Anonymous]

Hi

I just noticed there are still Nulls in SLA TP99 and SLA FCI in the Top table , please find the attached app again

Thanks

!

[Anonymous]

Can someone please look into this