Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Expression issue

Hi

I have a plot-chart with 2 dimensions :   MONTH  ,  YEAR

and one expression  :      Sum(   Value) 

My objective is to change the expression to transform it in an index as

Sum( Value) /  Sum(  the value of first month) 

How to write the denominator taking account the first month for each years in my expressions

Thanks for your help

JJ

1 Solution

Accepted Solutions

Re: Expression issue

Try something like

Sum(Value)/Sum(TOTAL <YEAR> {<Month={'Jan'}>} Value)

5 Replies

Re: Expression issue

Try something like

Sum(Value)/Sum(TOTAL <YEAR> {<Month={'Jan'}>} Value)

Not applicable

Re: Expression issue

Thanks Cel

What about if my first month is not Jan ?

JJ

Re: Expression issue

You mean it differs for every year?

Not applicable

Re: Expression issue

Yep! Thanks for tour effort

MVP
MVP

Re: Expression issue

Have you tried already with the chart inter record functions, namely top()?

Community Browser