4 Replies Latest reply: Jun 1, 2017 2:20 AM by Sibusiso Phumelo RSS

    Qlik Sense Num Format for Calculated Dimension

    Hari Nag

      Hi All,

      This is In Qlik Sense

      I am trying to convert one dimension in to Number format.

      Dimension Called Project Number and I need to show the all the Active project numbers. so I have written like this

       

      Dimension:

      if(Status='Active', [Project Number]) in the front end.

       

      But in the out put of this dimension I am getting in string format. I have tried both Num() and Num#()

       

      Num(if(Status='Active', [Project Number])),

      if(Status='Active', Num([Project Number]) ),

      Num#(if(Status='Active', [Project Number])),

      if(Status='Active', Num#([Project Number]) )

       

      But still I am getting in the string format.

       

      Please help.

       

      Thanks

      Prakash