topic Bug in Above() Function? in QlikView

Bug in Above() Function?

dwfiv327 — Tue, 21 Aug 2018 14:11:00 GMT

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?

name	date	time	comments	above(name)	above(date)
			-	-	-
apr	7/1/2018	11:00	comment one	-	-
apr	7/1/2018	12:00	comment two	apr	7/1/2018
apr	7/3/2018	9:00	comment three	-	-
bcr	7/1/2018	10:00	comment four	-	-

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

Re: Bug in Above() Function?

sunny_talwar — Tue, 21 Aug 2018 14:17:43 GMT

Use TOTAL qualifier when you have multiple dimensions

above(TOTAL name)

above(TOTAL date)

Re: Bug in Above() Function?

dwfiv327 — Tue, 21 Aug 2018 14:23:56 GMT

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

Re: Bug in Above() Function?

sunny_talwar — Tue, 21 Aug 2018 14:29:09 GMT

Check this link out

Missing Manual - Above() and Below()