Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nilsgc
Contributor III
Contributor III

Bypassing dimension

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

1 Solution

Accepted Solutions
nilsgc
Contributor III
Contributor III
Author

Hi,

I found a solution : The Above() function

Thanks for your input

Br

Nils

View solution in original post

6 Replies
MayilVahanan

Hi

Try like this

Expression :

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

Hope that helps

Thanks & Regards,
Mayil Vahanan R
nilsgc
Contributor III
Contributor III
Author

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

MayilVahanan

HI

Check the attached file. Hope it helps

Thanks & Regards,
Mayil Vahanan R
nilsgc
Contributor III
Contributor III
Author

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

MayilVahanan

Hi

Can you post a sample file?

Thanks & Regards,
Mayil Vahanan R
nilsgc
Contributor III
Contributor III
Author

Hi,

I found a solution : The Above() function

Thanks for your input

Br

Nils

View solution in original post