Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

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

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

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

Hi,

I found a solution : The Above() function

Thanks for your input

Br

Nils

View solution in original post