Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Number format not display correctly on Chart

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

Number Format.JPG

vMeasure =1

Number Fornmat vMeasure1.JPG

vMeasure = 3

Number format vMeasure3.JPG

vMeasure = 4

Number Fornmat vMeasure4.JPG

11 Replies
Highlighted
Partner
Partner

Re: Number format not display correctly on Chart

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'),...)

Highlighted
Creator
Creator

Re: Number format not display correctly on Chart

Hi AM van Keep

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

Kind regards

Nayan

Highlighted

Re: Number format not display correctly on Chart

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

Highlighted
Creator
Creator

Re: Number format not display correctly on Chart

Hi AM van Kemp

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

Kind regards

Nayan

vMeasure- AM Kemp.JPG

Highlighted
Creator
Creator

Re: Number format not display correctly on Chart

Hi Avinash

The Number format is set to "Expression Default"

Kind regards

Nayan

Expression default.JPG

Highlighted
Creator
Creator

Re: Number format not display correctly on Chart

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 .

Regards,
Afsar Shaikh
Project Manager- QlikView Dev. & Support
Afsar Shaikh
Email- afsar.shaikh@live.com
Highlighted

Re: Number format not display correctly on Chart

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

Highlighted
Creator
Creator

Re: Number format not display correctly on Chart

Hi Avinash

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

Kind regards

Nayan

Highlighted
Creator
Creator

Re: Number format not display correctly on Chart

Hi Afsar

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

Kind regards

Nayan