topic Re: Change the expression values on bar chart in QlikView

Change the expression values on bar chart

Tue, 23 Sep 2014 06:03:56 GMT

how to change the expression values in the above bar chart.

ex:- i want the expression start from 100.

arulsettu — Tue, 23 Sep 2014 06:06:27 GMT

amit_saini — Tue, 23 Sep 2014 06:07:06 GMT

Pu,

You can do the needful here below:

Thanks,

arulsettu — Tue, 23 Sep 2014 06:07:52 GMT

or try this

sum(expression)/100

Tue, 23 Sep 2014 06:08:59 GMT

On the Axes tab of bar chart, use the Scale to set Minimum, Maximum and Steps.

Thanks,

Singh

Anonymous — Tue, 23 Sep 2014 06:11:20 GMT

Use the static Min,

alkesh_sharma — Tue, 23 Sep 2014 06:20:05 GMT

Use the Static Scaling,

GO to the AXIS tab, Put Hard coded Value of Static MIN , MAX and STEP.

Or you can can divide the whole expression value. I can see your Expression Scale as 10000, 20000 so on...

For Eg. Sum(Value)/100. This will return the expression value in 100s and your scale will be converted in to 100, 200 300 ans so on.....

Tue, 23 Sep 2014 07:11:00 GMT

Thank You