Discussion Board for collaboration on QlikView Scripting.
please can any help
Do you want to do not show null values (columns) or omit rows where expression is null?
Hi Clever Anjos,
Am looking for " omit rows where expression is null "
Qlikview will omit rows when all expressions return null or zero, is that your case?
It would be easier if you share a sample of your qvw
Preparing examples for Upload - Reduction and Data Scrambling
you can use
then goto presentation tab and click on supress zero values.
Hope it will help.
I wrote 4 expressions in that one is showing null.
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))
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
you got the solution or not?