topic Re: error mess? in QlikView

error mess?

Anonymous — Fri, 09 Jan 2015 08:25:25 GMT

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 ?

Re: error mess?

Gysbert_Wassenaar — Fri, 09 Jan 2015 08:40:26 GMT

See attached qvw.

Re: error mess?

Anonymous — Fri, 09 Jan 2015 09:24:36 GMT

in myscenarion i have 3 expr

then what would be the value of variable

Re: error mess?

Gysbert_Wassenaar — Fri, 09 Jan 2015 10:42:27 GMT

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, ....

Re: error mess?

Anonymous — Fri, 09 Jan 2015 10:49:21 GMT

can u give me the expression