Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

QS number format set to Auto why one chart auto display in million ?

Hi All

I have 2 chart .

Chart 1 it will display in many digit like S5,452,661.195.02

Chart 2 it display 138.26M

Both numbering format i set to auto.

My question is why chart 2 will know to convert the amount to million ? and chart 1 does not automatic convert to million.

Paul

2 Replies
florentina_doga
Contributor III

Re: QS number format set to Auto why one chart auto display in million ?

see this

Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]


/1000000)

paulyeo11
Valued Contributor II

Re: QS number format set to Auto why one chart auto display in million ?

Hi Flor

Thank you for your reply. I am aware that i can use /1000000 for make it display in million. My doubt is why both chart return different number format ? as both of expression i never add /1000000 ?

Community Browser