7 Replies Latest reply: Jan 19, 2018 9:11 AM by Anil Samineni RSS

    Help with Num() (QLIKVIEW)

    Saimeenakshi Sankar

      Dear All,

       

      This is my expression: =Num(Count(if(match(DEV_CODE,'NR'),INT_ORD_NO)))

      Result: 14366

      Requirement is to display the numbers with comma in the Textbox (KPI)

       

      Issue: if I use the expression =Num(Count(if(match(DEV_CODE,'NR'),INT_ORD_NO)),'##,##0')

      I am getting the below result:

      Could someone help me if I am missing something>

       

      P.S: I have also tried with NUM#() with 'ThousandSep'