topic Re: Get the Max per Row and its Date in QlikView

Get the Max per Row and its Date

Mon, 10 Nov 2014 14:43:30 GMT

Hello,

I have the following table:

Where:

So XK is related to XTD, YK is related to YTD and ZK is related to ZTD.

What I need is to get the max value between XK, YK and ZK for each row and also return the date for the corresponding Power.

In this example I should get:

Do you know how could I do this?

I'd prefer doing this in the script.

Thank you!

MK_QSL — Mon, 10 Nov 2014 15:04:50 GMT

Load RowNo() as NO, * Inline

[

ID, XK, XTD, YK, YTD, ZK, ZTD

100, 0.12, 18/09/2013 17:28, 0.25, 10/09/2013 13:25, 0.08, 28/09/2013 22:10

100, 0.23, 18/10/2013 17:35, 1.38, 27/10/2013 7:53, 0.17, 12/10/2013 1:38

100, 0.22, 19/11/2013 17:18, 0.20, 05/11/2013 7:39, 0.10, 17/11/2013 18:17

];

Create a Straight Table

Dimension

NO
ID

Expressions

RangeMax(XK,YK,ZK)

IF(RangeMax(XK,YK,ZK) = XK, XTD,

IF(RangeMax(XK,YK,ZK) = YK, YTD, ZTD))

Go to presentation tab and select NO and Hide this column

Mon, 10 Nov 2014 15:55:53 GMT

Great! Thank you very much!