2 Replies Latest reply: May 3, 2017 9:17 AM by Aniruddhya Dutta RSS

    Max on Varchar in Qlik

    Aniruddhya Dutta

      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