Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

null values in current month vs previous month

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

6 Replies
vishsaggi
Champion III
Champion III

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

Not applicable
Author

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
Champion III
Champion III

In the presentation tab  did you check supress zero values ?

Not applicable
Author

Yes i did it but no use

vishsaggi
Champion III
Champion III

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

Anil_Babu_Samineni

What expression you've tried for observers

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful