Max on Varchar in Qlik

[aniruddhyadutta]

Hi All,

Please help me on the below issue

I have the following table

I am using the below code in qlik

LOAD

     PROC_ID,

     Max(SHORT_MSG) as RULE_ID_TRAN

     FROM datasource

group by PROC_ID ;

its giving me the below result

but the issue is in the database when we are doing max(SHORT_MSG) its returning the max of the varchar  as below which I need

it seems Qlik it doing a max only the numeric fields.How to do a max on all the varchar fileds as above?

I tried converting datatype as text but with no luck.

Cheers

AD

[sunny_talwar]

May be try MaxString(SHORT_MSG)

[aniruddhyadutta]

Thans Sunny