Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More

How to highlight the nearest value to median ?

I have created a table in which is calculated a median. I would like to highlight only one line : the one where the value is the nearest to the calculated median.

A way to do it is to calculate the difference between the value on each line, transform it to unsigned value and then retain the min of those values.

... But I just can't get it ? Can you help ?

You will find an application herejoined.

Thanks a lot !

Tags (1)
1 Reply
Not applicable

How to highlight the nearest value to median ?

Could you check this app ? I did it.