Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Using group dimension in expression.

hi

      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

1 Solution

Accepted Solutions
v_iyyappan
Valued Contributor

Re: Using group dimension in expression.

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

3 Replies
v_iyyappan
Valued Contributor

Re: Using group dimension in expression.

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

MVP
MVP

Using group dimension in expression.

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.

Not applicable

Using group dimension in expression.

Thanks alot, its working fine.

Community Browser