NoData

[soniasweety]

Hi all,

I have a straight table in my Qs application.

in that I have one measure column ,as per data there is no data for that in future it will come,

as per my req I want to show when ever there is no data I want to display no data for this chart?

how to achieve this?

Thanks

Sonica

[md_qlikview]

Hi,

You can write if condition in your set expression like.

If (sum(sales)=0 or Sum(sales)=null() or  sum(sales)='', 'no data', sum(sales)

[bohravanraj]

In Qlikview,

There is Calculated Condition where you can write this condition.

In Qliksense,

under Data handling tab for chart we can write this condition and even write an error message which should prompt.

Regards,

Vanraj Dinesh Bohra

[soniasweety]

thanks will try and let you know