Error handling in qlik sense

[abhijith28]

Hi,

someone please help me with the solution,

I have KPI object: sum({dates<dates={'=max(dates)'}>}sales),</dates={'=max(dates)'}>

where the sales values are null for many dates.

Suppose if i select the dates filter, the KPI object displays: "Data visualization fails to render".

Instead i have to display data not available

[Gysbert_Wassenaar · Accepted solution]

Perhaps this expression will do:

If(sum({dates<dates={'=max(dates)'}>}sales), sum({dates<dates={'=max(dates)'}>}sales), 'No data available')

[abhijith28]

Thank you so much, it is working fine.

But there is one issue,  i have two measures in single KPI differentiated by two dates with red n green color accordingly.

Based the > and < (red n green) color are dynamic.

If the above solution is implemented the current color red or green will be applied. I need single color to be displayed when the data is null.

Is it possible to implement it in Data Handling