topic using if condition in Expression in QlikView

using if condition in Expression

raghavsurya — Sat, 19 Jun 2010 08:16:44 GMT

Hi,

I am building a guage chart wherein I need to get the % of Acutal Revenue against the Projected Revenue if the year is 2009. In the Sales Table I have the following columns.

1, Year

2, Actual Sales

3. Actual Services

4. Projected Sales

5. Projected Services.

I have defined the expression as below

(sum(if(Year='2009',([Actual Sales])+ [Actual Service])))/(sum(if(Year='2009',([Projected Sales]+ [Projected Services]))))

But this expression is not returning any values.

Can anybody please point out the issues in the expression.

Thanks and Regards,

Raghav

using if condition in Expression

Sat, 19 Jun 2010 11:07:29 GMT

hi ,

I think there is no such issue with expression , can u send a sample qvw file for same

ashwin

using if condition in Expression

Sat, 19 Jun 2010 11:07:30 GMT

hi ,

I think there is no such issue with expression , can u send a sample qvw file for same

ashwin