Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense 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