topic Re: How do you dynamically set a number format in a linechart in App Development

How do you dynamically set a number format in a linechart

Anonymous — Wed, 07 Mar 2018 17:20:23 GMT

Hi everyone,

I have a line chart where I want to set the number format dynamically based on a variable.

For my measure I want to be be able to toggle between Num(Sum(Sales), '0.000') or Num(Sum(Sales), '$#0.00')

Both of these measure work individually. However, when I put them in an if statement, the number format stops applying:

If( True(), Num(Sum(Sales), '0.000') , Num(Sum(Sales), '$#0.00'))

Does anyone have any idea how I can get this resolved?

Thanks in advance

Re: How do you dynamically set a number format in a linechart

john_obrien — Wed, 07 Mar 2018 18:37:38 GMT

Colm,

It looks like it should work to me. The True() looks like it is just for testing - how are you getting the value of the variable in the If statement?

Re: How do you dynamically set a number format in a linechart

Anonymous — Thu, 08 Mar 2018 10:17:31 GMT

Hi John,

Thanks for the reply. The True() is just for testing - I want to get the expression working with that before looking into the variable.

You can reproduce the behavior I'm looking on Qlik Sense Feburary 2018 edition with the following:

Load Script:

LOAD * INLINE

[

Item,Sales

A, 100

B, 200

]

Charts:

Line chart one (working, formatted with dollar)

Dimension: Item

Measure: Num(Sum(Sales),'$#.00')

Line chart two (working, formatted with four decimals)

Dimension: Item

Measure: Num(Sum(Sales),'#.0000')

Line chart three (not working, if statement)

Dimension: Item

Measure: If(True(), Num(Sum(Sales),'$#.00'), Num(Sum(Sales),'#.0000'))

In all cases, the number formatting dropdown on the measure is set to 'Auto'

Re: How do you dynamically set a number format in a linechart

hacr — Thu, 08 Mar 2018 14:00:41 GMT

What is True() evaluating? Won't it always return "-1" in your expression?

Re: How do you dynamically set a number format in a linechart

Anonymous — Thu, 08 Mar 2018 14:10:57 GMT

Yes, I've just added the true() as a test. In my real expression I would have a variable here that would vary between true() and false().

Re: How do you dynamically set a number format in a linechart

shraddha_g — Thu, 08 Mar 2018 14:15:14 GMT

You can create 2 buttons to toggle between.

Try extension http://branch.qlik.com/#!/project/56728f52d1e497241ae697f8

If you are using a variable named vVar for buttons with values 1 and 2, then your expression will be

if(vVar = 1, Num(Sum(Sales), '0.000') , Num(Sum(Sales), '$#0.00') )

Re: How do you dynamically set a number format in a linechart

john_obrien — Fri, 09 Mar 2018 02:51:07 GMT

Colm,

I tried it and got it to work when the Number Formatting for the column was set to Auto or Measure expression.

Did you have any luck yet?

Re: How do you dynamically set a number format in a linechart

Anonymous — Fri, 09 Mar 2018 14:26:02 GMT

John,

Ok, that's weird! I have the exact same set up and yet the formatting is not being applied.

I'm on Qlik Sense Desktop Februry 2018 (12.5.2), what version are you on?