Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aniruddhyadutta
Creator
Creator

Max on Varchar in Qlik

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

2 Replies
sunny_talwar

May be try MaxString(SHORT_MSG)

aniruddhyadutta
Creator
Creator
Author

Thans Sunny