topic Re: Supress Null in Expression in QlikView

Supress Null in Expression

Thu, 29 Aug 2013 07:44:51 GMT

Hi All,

I have a straight table which is having 8 dimensions and one expression.

I am getting null values in the expression field. I want to supress the null values in expression.

We have supress null for dimensions..do we have same feature for expression?

My expresion is

=If(Date(LOAD_DATE) >= Date(From_date) and Date(LOAD_DATE) <= Date(To_Date) , Sum(Net_Creditable_Amount)

I don't want to supress the zero values beacuse according to my requiremtn zero values in the expression needs to be displayed in the chart.

Can somebody suggest ideas?

Thanks in advance

Thanks and Regards,

Praveena

Re: Supress Null in Expression

nilesh_gangurde — Thu, 29 Aug 2013 07:48:46 GMT

Hii Praveena,

Write the above code using set analysis.

Sum({<LOAD_DATE = {">= $(=Date(From_date))<= $(=Date(To_Date))"}>}Net_Creditable_Amount)

Hope this will help.

-Nilesh

Re: Supress Null in Expression

Thu, 29 Aug 2013 08:16:57 GMT

Hi Nilesh,

Thanks for the quick reply.

How this expression helps in supressing the nul rows?

when I applied this expression I am not getting the proper number of rows in the straight table

Thanks and Regards,

Praveena

Re: Supress Null in Expression

Thu, 29 Aug 2013 08:27:52 GMT

an idea:

if(Sum({<LOAD_DATE = {">= $(=Date(From_date))<= $(=Date(To_Date))"}>}Net_Creditable_Amount) >=0,Sum({<LOAD_DATE = {">= $(=Date(From_date))<= $(=Date(To_Date))"}>}Net_Creditable_Amount),'')

Re: Supress Null in Expression

nilesh_gangurde — Thu, 29 Aug 2013 08:31:33 GMT

Hii Praveena,

if you use the IF statement in the expression it will show the null values where the condition not get satisfied i.e. Load Date.

if you use the set analysis then QV will display only the records where Load Date is between From_date and To_Date.

-Nilesh

Re: Supress Null in Expression

abeyphilip — Thu, 29 Aug 2013 09:25:22 GMT

Hi Praveena,

How about having an IsNull(current expr) (or not IsNull()?) check around your current expression and then filter out the nulls.

Regards,

Abey

Re: Supress Null in Expression

Thu, 29 Aug 2013 09:29:46 GMT

You can use set analysis as QlikView automatically suppresses null values in set analysis.

Regards,

Basil