topic Re: Numbers not formatting - bar chart in QlikView

Numbers not formatting - bar chart

zagzebski — Sun, 04 Jun 2017 16:23:33 GMT

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

Re: Numbers not formatting - bar chart

vishsaggi — Sun, 04 Jun 2017 16:40:59 GMT

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?

Re: Numbers not formatting - bar chart

vinieme12 — Sun, 04 Jun 2017 19:06:31 GMT

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

Preparing examples for Upload - Reduction and Data Scrambling

Re: Numbers not formatting - bar chart

zagzebski — Mon, 05 Jun 2017 01:32:25 GMT

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.

Re: Numbers not formatting - bar chart

prma7799 — Mon, 05 Jun 2017 03:18:26 GMT

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

Re: Numbers not formatting - bar chart

vinieme12 — Mon, 05 Jun 2017 08:11:28 GMT

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!

Re: Numbers not formatting - bar chart

zagzebski — Mon, 05 Jun 2017 13:03:33 GMT

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