Yes its possible use more than one expressions in a chart. Also you can achieve conditional expressions using set analysis.
I've attached a qvw file. that shows sample solution for your problem.
test_bar_with_2expr.qvw 119.8 K
Hi Thanks for your reply... I used the expression that you provided and was going to test it but I found out something else that is also not working correctly so I have to fix that first..
I am using a date function to convert julian date (DB2) to MM/DD/YYYY format. For this the following date expression works....
date (makedate(1900 + floor(QRUPMJ/1000),1,1)+num(right(text(QRUPMJ),3))-1,'MM/DD/YYYY') as SalesDate
Then based on variable SalesDate I am using functions day & month as.....
day(SalesDate) as SalesDay,
month(SalesDate) as SalesMonth
to get the values for day and month. Somehow these functions are returning incorrect values. So the value in SalesDate is correct but the values in SalesDay and SalesMonth are not correct.
What am I doing wrong?