Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

above return NULL on the first dimension

I have the following Data

Dimension : 2013 - 2012 - 2011

Expression: = above([Trade Receivables]) - ([Trade Receivables]

Now, when i run the formula and i select the dimensions 2011 - 2012 - 2013, i have the following results

    

2011     : -

2012     : 5.000

2013     : 7.000

How can I change the formula so that the data for 2011 dissapears ? I would like to select the data 2012 - 2013 in my dimenstion and obtain the same results as above without 2011.

thanks for you help in advance

11 Replies
Not applicable
Author

working. Thanks a lot

fernando_tonial
Employee
Employee

Hi, you can try this:

RangeSum(above([Trade Receivables])) - Sum([Trade Receivables])


Best Regards

Tonial.

Don't Worry, be Qlik.