topic Using group dimension in expression. in QlikView

Using group dimension in expression.

Mon, 13 Feb 2012 09:32:34 GMT

i m using this expression in a chart

(Sum(s_revenue)+sum(mrevenue))/(Sum(total <year> srevenue)+sum(total <year> mrevenue))

Its working fine. But actually i want , this expression work for drildown according timegroup dimension also.

timegroup is group of dimension:

Year

Quarter

Month

Week

Day

So now my expresion should be like.

(Sum(s_revenue)+sum(mrevenue))/(Sum(total <timegroup > srevenue)+sum(total <timegroup > mrevenue)) .

But its expression showing error and its not working at all. Can we use dimension group in chart expression?

Thanks

v_iyyappan — Mon, 13 Feb 2012 09:43:02 GMT

Hi,

Use the Expression Like this

(Sum(s_revenue)+sum(mrevenue))/(Sum(total <Year,Quarter,Month,Week,Day> srevenue)+

sum(total <Year,Quarter,Month,Week,Day>mrevenue))

Regards,

Iyyappan

jagan — Mon, 13 Feb 2012 09:51:00 GMT

Hi,

You can use the below expression

= (Sum(s_revenue) + Sum(mrevenue))/

(Sum(TOTAL <Year,Quarter,Month,Week,Day> s_revenue) + Sum(TOTAL <Year,Quarter,Month,Week,Day> mrevenue))

Based on the field in the Drilldown group the dimension in the TOTAL <> is considered and ignores the remaining fields.

Regards,

Jagan.

Mon, 13 Feb 2012 12:41:58 GMT

Thanks alot, its working fine.