Supress Null in Expression

[#1]

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

[nilesh_gangurde]

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

[#3]

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

[#4]

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

[nilesh_gangurde]

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

[abeyphilip]

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

[#7]

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

Regards,

Basil