Below()

[timpoismans]

Hi all

I might just be misunderstanding the purpose of the function, or just not seeing it, but I tried the following:

CheckID	UserID	PageAccessTime	Below(PageAccessTime)
502471	223	3/01/2018 9:26	-
502472	223	3/01/2018 9:26	-
502473	223	3/01/2018 9:27	-
502474	223	3/01/2018 9:32	-
502475	223	3/01/2018 11:03	-
502476	223	3/01/2018 11:03	-
502477	223	3/01/2018 11:04	-
502478	223	3/01/2018 11:05	-
502479	223	3/01/2018 11:10	-

And it just doesn't work.

CheckID is an ID generated in the script, so all rows follow on eachother (Which shouldn't even be necessary for below), but when I use Below() on my Timestamp, it just returns Null().

Any help would be appreciated.

[vvira1316]

Below function evaluates an expression for the # (based on offset) of record below the current record

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inte...

In your case you don't have an expression

if you want to do it in script then you may want to use peek

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/InterReco...

[dplr-rn]

Try Below(Only(PageAccessTime))

[timpoismans]

Even when using an expression, like Sum(), Below() still doesn't function within my table:

And I read the help page, but it mentions expression or field, so I thought it would be possible without measure.

[timpoismans]

Tried, but didn't work. Still gives a Null() value as result

[timpoismans]

Edit:

Having more than one dimension and one measure in my table seems to break the Below() function:

(The black line is just there to make it clear it's two tables.)

Any ideas why this is happening?

[marcus_sommer · Accepted solution]

Instead of using the implicit/explicit only-aggregation just apply concat(Field, ' + ') to exclude a NULL (-error) in the case that there are multiple values available. Further just try it with a total, like: below(TOTAL concat(Field, ' + ')).

- Marcus

[timpoismans]

Hi Marcus

Adding the total fixed my issue, but could you explain me just how it fixed it? I don't understand why Below() wouldn't work without it in the first place.

Thanks in advance.

Regards,
Tim P.

[marcus_sommer]

I think the reason is that below() is in general calculated against a single dimension and if there is more than one it results in missing values for some rows or even in NULL. By applying a TOTAL statement it ignores this restriction respectively treated the multiplen dimensions as a single (merged) one. I fear it's not really a good explanantion, therefore take a look here:

Missing-Manual-Above-and-Below

- Marcus

[timpoismans]

It's an understandable explanation, so it works for me! 

Thanks again.