Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

mphekin12
Valued Contributor

Above Function

Hello,

I'm trying to show build the chart below using a straight table and thought it would be an easy Above() call.

Capture2.PNG

I cannot seem to get the 'Time of Row Above' column to calculate correctly.  This is what I currently have:

Capture1.PNG

Can anyone help me with this issue?

Thank you!

1 Solution

Accepted Solutions
Employee
Employee

Re: Above Function

If you have more than one dimension try using Above (Total yourexpression)

View solution in original post

10 Replies

Re: Above Function

Would you be able to share your application (sample)?

mphekin12
Valued Contributor

Re: Above Function

Sorry Sunny but there is data in the application that I cannot share.  All of the data is coming from one table.  I just need a way to show the date/time from the row above, then the difference between the current row date/time and the date/time from the row above it. 

Employee
Employee

Re: Above Function

If you have more than one dimension try using Above (Total yourexpression)

View solution in original post

Re: Above Function

What is your expression? Hopefully you have a TOTAL qualifier since you are dealing with multiple dimensions in your chart

I would think something along these lines:

Sum(Time) - Above(TOTAL Sum(Time))

Partner
Partner

Re: Above Function

Hi,

Just try above(CASE_TIMES_DT_TM).

Post your application with sample data.

-Sathish

mphekin12
Valued Contributor

Re: Above Function

Thank you Clever!  That worked perfectly.

mphekin12
Valued Contributor

Re: Above Function

Sathish,

Thanks for your reply but I tried that and it didn't work.  Using Above (Total your expression) as Clever suggested worked for me.

mphekin12
Valued Contributor

Re: Above Function

Sunny,

I didn't have a TOTAL qualifier.  That seemed to do the trick.

Thank you for your help!

Re: Above Function

Not a problem, glad we were able to help