How to use aggregate functions on multiple columns in a chart

[#1]

Hi,

I have an case query like

select col1,

col2,

col3,

sum(col6),

sum(col7)/sum(col8) from

(select col1,col2,col3,col4,col5,sum(a*b) as col6,case when b='ABC' then sum(c*d) end as col7,case when c='ABC' then sum (a*c)/b end as col8

from table1,table2

where table1.colA=table2.colB

group by col1,col2,col3,col4,col5) group by col1,col2,col3;

How can I achieve this in Qlikview Chart?