error mess?

[Anonymous]

i have fields called  products and Sales

i have a bar chart with this products  and sum(Sales) as expression  fine.

here  my req is

in chart as per req i created calculation condition count(products)<=1  if they select  more than  1 products then it is going to display error mess called  'select only one product'

fine this is also working

here:

product is having data like

products:

apple

banana

orange

sapota

jama

here i have no data for jama  and orange when i select orange or jama chart shows blank (because no data for these 2)

here i want display error mess  when i select orange or jama it should give like 'no data for this '

how to do this ?

possible how to do this in dynamically

because i have 100 names in products ,if there is no data for 20 products how can i give dynamically.

finally saying when data is there it will display chart , when we select more than one it gives error mess like select only one

when data is not there it should display error mess is 'data is not avliable'?

how ?

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[Anonymous]

in myscenarion i have 3 expr

then what would be the value of variable

[Gysbert_Wassenaar]

No data means that none of the three expressions return a value other than zero. So you need to include an if clause that includes all the expressions: if(expr1 <> 0 and expr2 <>0 and expr3<>0, ....

[Anonymous]

can u give me the expression