Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Above Function in chart

Hi,

I want to create a column  as shown below:

I want to do (Current Row -  Above Row)

Example: For Date 3rd: Value is 36.5797364796

For Date 4th: 65.4757850231-365797364796

And so on.

Above function is not working in my straight table expression. Can you flash your help, please?

Date ValueWant to create this column
11/03/1436.579736479636.5797364796
11/04/1465.475785023128.8960485435
11/05/14101.474855076735.9990700536
11/06/14122.161668467320.6868133906
11/07/14144.567198831322.405530364
11/09/14153.30391311068.7367142793
11/10/14218.390216279565.0863031689
11/11/14249.754832512531.364616233
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Above Function in chart

sum

( Value) - above( sum( Value ))

worked!

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Above Function in chart

sum

( Value) - above( sum( Value ))

worked!

View solution in original post

Highlighted

Re: Above Function in chart

Hi,

Write this expression

Below(sum(Value)) - sum(Value)

Regards

Anand