topic Re: how do we remove null values for a expression for straight table in qlik view in QlikView

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

Wed, 07 Oct 2015 14:25:23 GMT

please can any help

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

Clever_Anjos — Wed, 07 Oct 2015 14:31:24 GMT

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

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

Wed, 07 Oct 2015 14:51:29 GMT

Hi Clever Anjos,

Am looking for " omit rows where expression is null "

Thanks

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

Clever_Anjos — Wed, 07 Oct 2015 14:54:21 GMT

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

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

Clever_Anjos — Wed, 07 Oct 2015 14:55:19 GMT

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

Preparing examples for Upload - Reduction and Data Scrambling

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

raghvendrasingh — Wed, 07 Oct 2015 15:01:23 GMT

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

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

Wed, 07 Oct 2015 15:08:39 GMT

Hi Clever,

I wrote 4 expressions in that one is showing null.

Thanks

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

Clever_Anjos — Wed, 07 Oct 2015 16:34:41 GMT

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

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

vikasmahajan — Thu, 08 Oct 2015 04:45:03 GMT

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

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

Thu, 08 Oct 2015 07:23:46 GMT

HI Reddy,

you got the solution or not?

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

Thu, 08 Oct 2015 14:42:46 GMT

Hi Nitish,

No , still am facing difficulty please can you help

Thanks