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?
No , still am facing difficulty please can you help
Retrieving data ...