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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.