topic Number format not display correctly on Chart in QlikView

Number format not display correctly on Chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I'm struggling to get the number format correct in a chart table. The number format works perfectly fine when paste the formula in a text box. I've checked the Number tab on the chart and this expression is set to "Expression Default".

Below is my expression and further below are results three of the vMeasure selected. (I've shown both values together, the blue being the number format in a text box).

Thank you.

Kind regards

Nayan

vMeasure =1

vMeasure = 3

vMeasure = 4

Re: Number format not display correctly on Chart

avkeep01 — Mon, 30 Oct 2017 09:01:26 GMT

Hi nayanlalla‌, maybe you should use a PICK function. Which works as follows,

PICK(<number>,<function 1>, <function 2>,<function n>)

the number is the part you want to use, so PICK(2,<function 1>, function 2>,<function n>) uses the second function. When using an IF statement, the expression will be calculated in total every time. In a pick function only the part choosen will be calculated.

PICK($(vMeasure),NUM($(vSpend(vYTD)),'# ##0'),NUM($(vSavings(vYTD)),'# ##0'),...)

Re: Number format not display correctly on Chart

Anonymous — Mon, 30 Oct 2017 09:09:40 GMT

Hi AM van Keep

Thank you. I will try it out and let you know.

Kind regards

Nayan

Re: Number format not display correctly on Chart

avinashelite — Mon, 30 Oct 2017 09:19:28 GMT

check the formatting you have defined in the chart properties > Number tab > Make it expression default and check once

Re: Number format not display correctly on Chart

Anonymous — Mon, 30 Oct 2017 09:21:42 GMT

Hi AM van Kemp

I've tried your expression, but no change in the result. Here is the expression below.

Kind regards

Nayan

Re: Number format not display correctly on Chart

Anonymous — Mon, 30 Oct 2017 09:24:11 GMT

Hi Avinash

The Number format is set to "Expression Default"

Kind regards

Nayan

Re: Number format not display correctly on Chart

afsarshaikh — Mon, 30 Oct 2017 09:27:33 GMT

Is that expression working? I believe there's an extra comma(,) at the last If condition.

Kindly try removing it and apply the changes with the Expression Default on the Number Tab and close the Parenthesis for every If condition .

Re: Number format not display correctly on Chart

avinashelite — Mon, 30 Oct 2017 09:30:01 GMT

could you share the sample app , will check and get back to you ?/

Re: Number format not display correctly on Chart

Anonymous — Mon, 30 Oct 2017 09:41:56 GMT

Hi Avinash

I'll see what i can do as it is sensitive data. Maybe create one with scrambled data.

Kind regards

Nayan

Re: Number format not display correctly on Chart

Anonymous — Mon, 30 Oct 2017 09:42:52 GMT

Hi Afsar

Yep, i did notice that and i have removed the comma.

Kind regards

Nayan

Re: Number format not display correctly on Chart

avkeep01 — Mon, 30 Oct 2017 09:49:41 GMT

Hi nayanlalla‌,

I created a qlikview file just for testing purpose. Maybe I'm not using the same underlying variables, but the formatting changes when I changes the variable vMeasure. I'll attach my qlikview example.

Re: Number format not display correctly on Chart

Anonymous — Mon, 30 Oct 2017 10:13:00 GMT

Hi AM van Keep

Thank you for your reply. Yep, it could be the variables. I'll investigate.

Kind regards

Nayan