topic Suppress Null within expression in QlikView

Suppress Null within expression

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to suppress the null value with in the expression.

Below is the logic i'm using

Logic: num(Sum(COMPLETE_MTD_NEW)/Sum(aggr(Sum(TOTAL_CONTRACTS_MAY1ST_NEW),A7AACD)),'##.00')*100

Thanks,.

Re: Suppress Null within expression

sunny_talwar — Tue, 20 Sep 2016 10:04:12 GMT

Not sure what you mean when you say suppress null values in the expression? When you use this expression you see null values?

Re: Suppress Null within expression

nareshthavidishetty — Tue, 20 Sep 2016 10:23:55 GMT

Hi Sunny,

Please find below image

In the above image the trend line indicates cumulative count (MTD) and the bar chart indicates daily count, here the trend line for location 027 has data as it is MTD but for daily the count for location 027 is zero.

As we have used 2 charts to get the above requirement by making transparency of 1st chart which having bar and line trend and to get the horizontal values on top of bar we have used trendline in the 2nd bar chart.

So, because of the null data for daily the values on top of the bar are slightly not alligned.

Thanks,..

Re: Suppress Null within expression

sunny_talwar — Tue, 20 Sep 2016 10:44:06 GMT

I kind of understand what the issue is, but would it be possible to share a sample to have a closer look at this and try out few things?

Re: Suppress Null within expression

Digvijay_Singh — Tue, 20 Sep 2016 11:44:18 GMT

You may have tried but just to confirm did you try to get the values in the 1st chart itself, having expression with values on data points without bar and line.