Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

num() not working in if Statement

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!

10 Replies
Not applicable
Author

Did anyone come up with a solution for this issue? Is there any workaround?

I'm having exactly the same problem, and it looks like it's a bug/limitation in Qlik Sense.