Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dwfiv327
Contributor II
Contributor II

Bug in Above() Function?

Above seems to not we working as expected.  I thought it would just return the value in the row above the current one, but that does not seem to be the case.  It only does so when the second column matches.  Why don't above(name) and above(date) have values in all but the first row?

 

namedatetimecommentsabove(name)above(date)
---
apr7/1/201811:00comment one--
apr7/1/201812:00comment twoapr7/1/2018
apr7/3/20189:00comment three--
bcr7/1/201810:00comment four--

Please let me know if I am doing something wrong or if it is indeed a bug.

1 Solution

Accepted Solutions
sunny_talwar

Use TOTAL qualifier when you have multiple dimensions

above(TOTAL name)

above(TOTAL date)

View solution in original post

3 Replies
sunny_talwar

Use TOTAL qualifier when you have multiple dimensions

above(TOTAL name)

above(TOTAL date)

dwfiv327
Contributor II
Contributor II
Author

That fixed it.  Not sure how one TOTALs text fields, but it works.

sunny_talwar