HI
I am trying to find the middle value in a qliksense table.
Example: If a dimension has 400 rows, then the middle value is 200 and then peek the value in row number 200.
If the number of rows is ODD, then pick the next value.
No of rows: 400(even) --> Middle value = 200
No of rows: 401(odd) --> Middle value = 201.
So find the middle row number and peek the corresponding value in that row number 200 or 201.
I have also given a detailed question in the following link, Find middle value in a column and pick the other c... - Qlik Community - 1920423
Thanks.
Please help.