Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

alternate option for above()

Is there any alternate option for above()?

By using above() function, the chart becomes static - position dependent.

Further slice and dice is not possible.

Please suggest some way. I read another thread about SET Analysis, but I've not yet used SET Analysis.

3 Replies

alternate option for above()


It depends very much on what kind of chart you want to display. Inter-record functions will work in both pivot and straight tables, but of course as you are referring to positions (above, left, bottom...) if your dimension or expression changes position, the formula will be affected.

On the other hand, set analysis may help of course, but please specify on what you want to get.



alternate option for above()

These sorts of problems can also often be solved with linkage tables that tie a record to the "above" record. I can't get much more specific without knowing what you want, though.

Not applicable

alternate option for above()

Thanks a lot for all replies.

I'll try - check wheteher I can solve my issue with linkage tables.

If I couldn't, will revert back.

Thanks for your time.

Community Browser