NULL Value

[Anonymous]

Hello All

Please help me in the below query. I do not know if it is possible or not in Qlik Sense

Please suggest.

In the below attached screen shot,for Bar graph, I have NULL value in the data. I want to use the formula which tells that when there is value it shows the amount and when there is no data it shows the comment that "Data is not available". Just like the Pie-Chart takes default comment.

Formula I used:

IF(len(trim(Department)) > 0, Sum(Amount))

Please suggest.

Thanks

DC

[vinieme12 · Accepted solution]

Add Calculation condition and Your custom message as below

[Anonymous]

Thanks sir!!

I have tested the formula on my dummy data.. Its work well.

I will put the formula on my main data and posted the same if something go wrong.

Just a request can you please make me understand how it works?

Thanks

DC

[vinieme12]

1  means Yes, 0 means No

so when you put  the formula in Calculation condition your saying that : if count of department is less than 1 then NO else Yes.

so Calculate = No or Calculate = Yes, based on your condition.