Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try MaxString(SHORT_MSG)
Thans Sunny