How to get output as first & maximum values in qlikview

[Anonymous]

hai experts.

I want  get output of a table values  (coloumn 2 marks values)as first & maximum values as output.

example:

Header 1	Header 2	Header 3	Header 4
student	marks	first value(output)	maximum value(output)
Ramu	343,567	343	567
Sunil	121,43	121	121

Thanks in advance.

[Anonymous · Accepted solution]

Hi,

You can use subfield function in the load script

subfield(marks,',',1) as First

subfield(marks,',',2) as Maximum

Regards,

[albertovarela]

Please see attached qvw...

[Anonymous]

Thanks, giving good suggestion.it's working.