Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

Hi

please can any help

10 Replies
Clever_Anjos
Employee
Employee

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

Not applicable
Author

Hi Clever Anjos,

Am looking for  " omit rows where expression is null "

Thanks

Clever_Anjos
Employee
Employee

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

Clever_Anjos
Employee
Employee

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

Preparing examples for Upload - Reduction and Data Scrambling

raghvendrasingh
Creator II
Creator II

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
Author

Hi Clever,

I wrote 4 expressions in that one is showing null.

Thanks

Clever_Anjos
Employee
Employee

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

HI Reddy,

you got the solution or not?