8 Replies Latest reply: Aug 16, 2017 4:17 AM by Prashanth Reddy RSS

    Num and Date and string Format in qliksense

    Manoranjan D

      Hi all,

       

      in the straight table i have given the expression as below

       

      =if(Metrics='Amount', sum({<[Primary Comparison Date]={'$(vMin)'}>}Amount),

      if(Metrics='Description',only({<[Primary Comparison Date]={'$(vMin)'}>}Description),

      if(Metrics='Modify Date',Date(only({<[Primary Comparison Date]={'$(vMin)'}>}[Modify date]),'MM/DD/YYYY'),

      )))


      i want to display the amount in the num format where if the amount has negative value it have show in the brackests (), how to achive this in the if loop