Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser22
Creator II
Creator II

Find middle value in qliksense table

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. 

 

 

Labels (5)
0 Replies