topic View records where null in QlikView

View records where null

Sunil_Kenth — Fri, 19 Aug 2011 22:58:43 GMT

HI,

I would like only to view in my straight table records where 'Date order placed' is blank.

This is expression i am using:

Sum( {$<[Date order placed]={“”}>} LineItems::PriceTotalSummary)

Can anyone tell me why this wont work?

Thanks.

Sunil

swuehl — Fri, 19 Aug 2011 23:07:06 GMT

I think that's because Null is not a value, so you can't select it (unless you specified NullAsValue in the load script).

But maybe this works:

sum(if(isNull([Date order placed])=-1, LineItems::PriceTotalSummary))

Regards,

Stefan

kaushiknsolanki — Sat, 20 Aug 2011 06:50:27 GMT

Hi,

Do following settings.

Go to dimension tab, Select the dimensions and uncheck the option "Suppress When Value is Null"

Go to Expression Tab -> Uncheck "Suppress Zero Value"

Regards,

Kaushik Solanki

ToniKautto — Sat, 20 Aug 2011 15:33:32 GMT

Maybe a if statement could be utilized if you are looking for Null values?

Sum( If( IsNull([Date order placed]) LineItems::PriceTotalSummary)