topic Re: Bypassing dimension in QlikView

Bypassing dimension

Anonymous — Mon, 15 Oct 2012 13:41:10 GMT

Hi,

I want to create a chart showing gross sales development, but I have a challange.
Currently I have data for 2011 and 2012. The user always have to select one year.
Dimension : Year

1) Show sales in year
Expression : sum({<Year=>} [Invoice Amount Group])

This work fine and shows a result for both 2011 and 2012

2) Show increase in %
Expression : sum({<Year=>} [Invoice Amount Group]) / sum({<Year={2011}>} [Invoice Amount Group])

This only shows a result for 2011. Where did 2012 go???

Any ideas to get 2) working

Kind regards
Nils

Re: Bypassing dimension

MayilVahanan — Mon, 15 Oct 2012 13:48:58 GMT

Try like this

Expression :

=sum({<Year={$(max(Year))}>} [Invoice Amount Group]) / sum({1} [Invoice Amount Group])

Hope that helps

Re: Bypassing dimension

Anonymous — Mon, 15 Oct 2012 20:42:04 GMT

Sorry... this dosen't help.

and next year I'll have 3 years of data ... 2013 must by compared against 2012, 2012 against 2011.... and so on

Any ideas?

Regards

Nils

Re: Bypassing dimension

MayilVahanan — Mon, 15 Oct 2012 20:53:38 GMT

Check the attached file. Hope it helps

Re: Bypassing dimension

Anonymous — Mon, 15 Oct 2012 21:05:23 GMT

Hi,

Thank you for your help, Mayil.

Your solution works fine with a fixed number of years.... but what if I want to use it with month as dimension. Then I'll have to repeat the expressions

I need it to be dynamic

Best regards

Nils

Re: Bypassing dimension

MayilVahanan — Mon, 15 Oct 2012 21:07:22 GMT

Can you post a sample file?

Re: Bypassing dimension

Anonymous — Tue, 16 Oct 2012 20:28:55 GMT

Hi,

I found a solution : The Above() function

Thanks for your input

Nils