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?
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)
thanks will try and let you know
There is Calculated Condition where you can write this condition.
under Data handling tab for chart we can write this condition and even write an error message which should prompt.
Vanraj Dinesh Bohra
Retrieving data ...