Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
zagzebski
Contributor

Numbers not formatting - bar chart

I have a bar chart with two dimensions (Location/Year) and two expressions:  the first expression is not part of the bar (unselected "Bar" and is only used for dimension limits. However I can not format the number of the second dimension at all. When I uncheck the "enable" of the first dimension the formatting works, but not when I select an "enable" of the expression then the formatting doesn't work. Unfortunately I need the first expression enabled for dimension limits.

Any help on why formatting won't work on the second expression if the first selection is Enabled?

Thanks,

Zag

6 Replies
vishsaggi
Esteemed Contributor III

Re: Numbers not formatting - bar chart

Can you elaborate a little. Quite did not get you. Can you share a sample qvw file or some screenshots where you facing the problem?

vinieme12
Esteemed Contributor II

Re: Numbers not formatting - bar chart

Cannot help you without a sample app, we need to see exactly whats happening

Preparing examples for Upload - Reduction and Data Scrambling

zagzebski
Contributor

Re: Numbers not formatting - bar chart

I have attached the images. I need the first expression enabled for dimension limits but if I do then the formatting of the second expression doesn't work.

prma7799
Honored Contributor III

Re: Numbers not formatting - bar chart

Try like this

=

Num(((Sum ([Metric Total Act Prim])+Sum ([Metric Ballast])+Sum ([Metric Weight])*Sum ([Metric Total Act Exc])+(1-Sum ([Metric Weight]))*Sum ([Metric Total Exp Exc]))
/(
Sum ([Metric Total Exp Prim])+Sum ([Metric Ballast])+Sum ([Metric Weight])*Sum ([Metric Total Exp Exc])+(1-Sum ([Metric Weight]))*Sum ([Metric Total Exp Exc])))
-
(
(((
Sum ([Metric Total Act Prim])-Sum ([Amount Claim Actual Primary]))+Sum ([Metric Ballast])+(Sum ([Metric Weight])*(Sum ([Metric Total Act Exc])-Sum ([Amount Claim Actual Excess])))+((1-Sum ([Metric Weight]))*Sum ([Metric Total Exp Exc]))))
/(
Sum ([Metric Total Exp Prim])+Sum ([Metric Ballast])+Sum ([Metric Weight])*Sum ([Metric Total Exp Exc])+(1-Sum ([Metric Weight]))*Sum ([Metric Total Exp Exc]))
) ,'#.###')

vinieme12
Esteemed Contributor II

Re: Numbers not formatting - bar chart

because you haven't formatted your First expression

Either format the Expression value using Num() or using the Number tab  >> Select Expression and >> Number formatting of your choice!

zagzebski
Contributor

Re: Numbers not formatting - bar chart

nope  - I tried formatting the first expression too - but still didn't help with the formatting of the second expression.