topic Re: Above Function in QlikView

Above Function

mphekin12 — Fri, 12 Feb 2016 15:48:12 GMT

Hello,

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

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

Can anyone help me with this issue?

Thank you!

Re: Above Function

sunny_talwar — Fri, 12 Feb 2016 15:59:55 GMT

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

Re: Above Function

mphekin12 — Fri, 12 Feb 2016 16:04:56 GMT

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.

Re: Above Function

Clever_Anjos — Fri, 12 Feb 2016 16:06:30 GMT

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

Re: Above Function

sunny_talwar — Fri, 12 Feb 2016 16:07:07 GMT

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))

Re: Above Function

sathishkumar_go — Fri, 12 Feb 2016 16:08:13 GMT

Hi,

Just try above(CASE_TIMES_DT_TM).

Post your application with sample data.

-Sathish

Re: Above Function

mphekin12 — Fri, 12 Feb 2016 16:13:35 GMT

Thank you Clever! That worked perfectly.

Re: Above Function

mphekin12 — Fri, 12 Feb 2016 16:14:54 GMT

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.

Re: Above Function

mphekin12 — Fri, 12 Feb 2016 16:15:57 GMT

Sunny,

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

Thank you for your help!

Re: Above Function

sunny_talwar — Fri, 12 Feb 2016 16:16:57 GMT

Not a problem, glad we were able to help

Re: Above Function

harsh44_bhatia — Fri, 12 Feb 2016 16:19:08 GMT

Hello,

Assuming that for each CT.CASE_NUMBER and CASE_TIMES_TYPE your dataset has unique CASE_TIMES_DT_TM. then use the following

code first expression as =Only(CASE_TIMES_DT_TM)

second Expression= Above(total aggr(Only(CASE_TIMES_DT_TM),CT.CASE_NUMBER,CASE_TIMES_TYPE ) ,1)

if you have multiple timestamp for Case_Number & Case_TIMES_TYPE then use aggregation function in the first expression, something like max(CASE_TIMES_DT_TM)