topic Re: If value is null in QlikView

If value is null

Thu, 03 Oct 2013 10:37:49 GMT

Hi,

I want to aradictae any null values in my dashboard, I have used the supress value when null option on the charts and tables, but I have text boxes with formulas/sums in the displaying information. These still include the null values.

I want it to say something like if specialty is null then 0 else sum funded equivalent. This is the coe I have at the moment. I don't know how to make sure if specialty is null then don't sum it...

=sum({<operation_type={'Elective'}>} funded_equivalent)

Please can you help?

Thanks,

Re: If value is null

Thu, 03 Oct 2013 11:57:30 GMT

There are two ways for it.

If you don't want to sum values if a spesific dimension value is null.

Then;

SUM( {< ColumnName = {"*"} >} Values ) > if you use "*" for a field in set analysis it eleminates null values

Also;

SUM( IF( Isnull( ColumnName ) , 0 , Values ))

Re: If value is null

Thu, 03 Oct 2013 12:15:43 GMT

Thank you so much