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



           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.