10 Replies Latest reply: Oct 31, 2016 7:52 AM by Pedro Miguel RSS

    num() not working in if Statement

    Vandy Anand

      I am having issues with if condition in Qlik sense app. I am trying to format measures based on variable. The format works by itself outside of the If statement but when I include it in if statement it does not work. Below is the statement

       

      The format works but 'k' does not show up on the charts. so the number 712100 shows as 712.1

      IF(fabs($($(vToggleDatePeriod)_New_$(vToggleLOB)_$(vToggleMetric)))>1000,num(round($($(vToggleDatePeriod)_New_$(vToggleLOB)_$(vToggleMetric))/1000,.1),'#,##0.0k;(#,##0.0k)'),

      round($($(vToggleDatePeriod)_New_$(vToggleLOB)_$(vToggleMetric)),.01))

       

      The below works and the measures on the bar  chart shows with the 'k' format. so the number 712100 shows as 712.1k

      num(round($($(vToggleDatePeriod)_New_$(vToggleLOB)_$(vToggleMetric))/1000,.1),'#,##0.0k;(#,##0.0k)')

       

      Thanks for help in advance!