topic Re: How to take Max value of alphanumeric field in QlikView

How to take Max value of alphanumeric field

santharubban — Mon, 14 Aug 2017 13:48:58 GMT

Hi All,

I need to get max value of alphanumeric field, can any one help assist the same.

Please find attached screen shot.

Expression : MaxString({<ACTIVE_ACTION_Flag = {1}>}total [End ID])

Thanks

Santharubban KS

Re: How to take Max value of alphanumeric field

sunny_talwar — Mon, 14 Aug 2017 13:53:34 GMT

May be this

Aggr(If(SubField([End ID]), '.', -1) = Max(TOTAL <[GPID N...]> SubField([End ID]), '.', -1)), [End ID]), [GPID N...], [End ID])

Re: How to take Max value of alphanumeric field

Kushal_Chawda — Mon, 14 Aug 2017 14:45:00 GMT

if the number are always separable by dot them try like below

LOAD GPID,

[Program ID],

[End ID],

subfield([End ID],'.',2) as Number

FROM QVD;

Now on front end, below expression should work

=max(total <GPID>Number)

Re: How to take Max value of alphanumeric field

santharubban — Mon, 14 Aug 2017 16:00:56 GMT

Thanks Sunny.

for Active action i am good but for Historized actions i am not able to get .

Re: How to take Max value of alphanumeric field

sunny_talwar — Mon, 14 Aug 2017 16:18:34 GMT

Not sure I understand?

Re: How to take Max value of alphanumeric field

santharubban — Mon, 14 Aug 2017 16:43:15 GMT

Hi Sunny,

If you see my attachment, I have 2 different action one is Active and or this History action. For Active an I am getting right result but for History action i am not get correct answer as i marked in my attachment.

Exp:

Aggr(if(HISTORIZIED_Flag = 1 and SubField(SubField([End ID],'_',-1),'.',-1) = (Max(SubField(SubField([End ID],'_',-1),'.',-1))), [End ID] ), [GPID Number],[End ID])

Re: How to take Max value of alphanumeric field

sunny_talwar — Mon, 14 Aug 2017 17:33:10 GMT

Can you post your application?

Re: How to take Max value of alphanumeric field

santharubban — Mon, 14 Aug 2017 17:54:42 GMT

please find attached sample applications

Re: How to take Max value of alphanumeric field

sunny_talwar — Mon, 14 Aug 2017 18:09:13 GMT

May be this

Aggr(If(HISTORIZIED_Flag = 0,

If(SubField([End ID], '.', -1) = Max(TOTAL <[GPID Number]> SubField([End ID], '.', -1)), [End ID]),

If(PurgeChar(SubField([End ID], '_', -1), 'H') = Max(TOTAL <[GPID Number]> PurgeChar(SubField([End ID], '_', -1), 'H')), [End ID])), [GPID Number], [End ID])

Re: How to take Max value of alphanumeric field

santharubban — Mon, 14 Aug 2017 18:50:17 GMT

Thanks Sunny I got it