Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

Hi

please can any help

10 Replies
Employee
Employee

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

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

Not applicable

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

Hi Clever Anjos,

Am looking for  " omit rows where expression is null "

Thanks

Employee
Employee

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

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

Employee
Employee

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

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

Preparing examples for Upload - Reduction and Data Scrambling

raghvendra_singh
Contributor II

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

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

Not applicable

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

Hi Clever,

I wrote 4 expressions in that one is showing null.

Thanks

Employee
Employee

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

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
Honored Contributor III

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

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

Not applicable

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

HI Reddy,

you got the solution or not?

Community Browser