This content has been marked as final. Show 2 replies
Please help me on the below issue
I have the following table
I am using the below code in qlik
Max(SHORT_MSG) as RULE_ID_TRAN
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.