topic Re: Removing values in an expression in QlikView

Removing values in an expression

Fri, 19 Sep 2014 15:40:53 GMT

I would like to remove (or display a null - blank) in place of any percentages 0 or less. I would like to do this in the expression and not the load script, if possible. I tried the code below but it didn't work. The data comes from the table already caculated as a percent. So, in the image below I just want a blank cell for -87%, -11% etc. It seems like this would be very simple, but can't get it to work. Thanks,

if(ContributionMarginPCT <= 0.00,null(),ContributionMarginPCT)

Re: Removing values in an expression

MK_QSL — Fri, 19 Sep 2014 15:45:10 GMT

IF(SUM(Sales)<=0,0,SUM(Sales))

so here

IF(YOUREXPRESSION <=0, 0, YOUREXPRESSION)

Re: Removing values in an expression

JonnyPoole — Fri, 19 Sep 2014 15:45:48 GMT

I think you need an aggregation function for the expression to evaluate properly. Try this:

if( sum(ContributionMarginPCT) <= 0.00,null(), sum(ContributionMarginPCT))

Re: Removing values in an expression

Fri, 19 Sep 2014 15:51:58 GMT

Thank you Manish - but now my code is working. Weird

Re: Removing values in an expression

Fri, 19 Sep 2014 15:52:56 GMT

Thanks Jonathan. I tried the code above and the percentages got all messed up, so I just tried my code again and it worked. Thanks for responding.