topic Re: null values in current month vs previous month in QlikView

null values in current month vs previous month

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I'm calculating the current months total sales and previous month total sale

i want a condition where current month sale is =0 then the previous month sale should be zero

For suppose in current month if i have only one country where sales aree done

i want to see that country in the previous month remaining should be null

belo is the senario

in the above image i'm getting data from the remaining countries as well i dont want to see the remining country data

vishsaggi — Mon, 31 Oct 2016 19:37:15 GMT

Did you try checking Supress value when null in the dimensions tab of your chart properties ? Can you share a sample app if possible?

Mon, 31 Oct 2016 19:41:43 GMT

yes i did it but the values i'm calculating are from expressions so no use on doing that

can we supress zeros in set expressions

vishsaggi — Mon, 31 Oct 2016 19:48:04 GMT

In the presentation tab did you check supress zero values ?

Mon, 31 Oct 2016 20:07:55 GMT

Yes i did it but no use

vishsaggi — Mon, 31 Oct 2016 20:17:18 GMT

Can you share your app or what is the expr you are using ?

Anil_Babu_Samineni — Tue, 01 Nov 2016 00:25:04 GMT

What expression you've tried for observers