how do we remove null values for a expression for straight table in qlik view

[#1]

Hi

please can any help

[Clever_Anjos]

Do you want to do not show null values (columns) or omit rows where expression is null?

[#3]

Hi Clever Anjos,

Am looking for  " omit rows where expression is null "

Thanks

[Clever_Anjos]

Qlikview will omit rows when all expressions return null or zero, is that your case?

[Clever_Anjos]

It would be easier if you share a sample of your qvw

Preparing examples for Upload - Reduction and Data Scrambling

[raghvendrasingh]

Hi,

you can use

if(isnull(yourexpression),0,yourexpression)

then goto presentation tab and click on supress zero values.

Hope it will help.

Thanks,

Raghvendra

[#7]

Hi Clever,

I wrote 4 expressions in that one is showing null.

Thanks

[Clever_Anjos]

you can change the expressions like

Exp1 (that will filter) = sum(value)

exp2 = if(sum(value), count(other))

exp3 = if(sum(value), count(another))

exp4 = if(sum(value), sum(other))

[vikasmahajan]

Hi,

In Reload you can put flags create filed like following and in set analysis you can skip this null records

if( PROD_GROUP_ID = 0,1,if(ISNULL(PROD_GROUP_NAME) OR LEN(PROD_GROUP_NAME)=0,1,0)) AS IsMissingProductGrp

HTH

Vikas

[#10]

HI Reddy,

you got the solution or not?