topic Re: Static Min, Static Max, Static Step in bar chart? in QlikView

Static Min, Static Max, Static Step in bar chart?

Thu, 03 Apr 2014 09:07:22 GMT

Hi,

How can I set the Static min, Static Max and Static Step for Bar chart. please can anyone suggest me.

Thanks.

Re: Static Min, Static Max, Static Step in bar chart?

Thu, 03 Apr 2014 09:07:35 GMT

Please see attached.

Re: Static Min, Static Max, Static Step in bar chart?

simondachstr — Thu, 03 Apr 2014 09:12:24 GMT

Properties -> Axes -> Static Min/Max

Voila.

Re: Static Min, Static Max, Static Step in bar chart?

Thu, 03 Apr 2014 09:15:23 GMT

Thanks. Sorry I know the location, but actually I need the values to type in Static Min, Static Max and Static Step? Please help

Re: Static Min, Static Max, Static Step in bar chart?

crusader_ — Thu, 03 Apr 2014 09:15:48 GMT

Hi Amelia,

Chart Properties - > Axes-> Scale -> Static Min / Max/ Step

Don't forget use number between 0 and 1 when work with percents.

To work wih Static Min correctly uncheck "Forced 0"

Kind regards,

Andrei

Re: Static Min, Static Max, Static Step in bar chart?

Thu, 03 Apr 2014 09:24:58 GMT

Thanks. Can I give the same values if I have two more expressions?

Re: Static Min, Static Max, Static Step in bar chart?

simondachstr — Thu, 03 Apr 2014 09:28:52 GMT

The values you need strongly depend on how you want to limit your axes. If 100% is your limit then you use 1.

Re: Static Min, Static Max, Static Step in bar chart?

crusader_ — Thu, 03 Apr 2014 09:33:12 GMT

Yes, you can

Re: Static Min, Static Max, Static Step in bar chart?

crusader_ — Thu, 03 Apr 2014 09:45:33 GMT

Also instead of static numbers you can use an expressions:

=max(Expression1)

=min(Expression1)

Re: Re: Static Min, Static Max, Static Step in bar chart?

manojkulkarni — Thu, 03 Apr 2014 10:35:05 GMT

Pls check attached file.

Re: Static Min, Static Max, Static Step in bar chart?

Thu, 03 Apr 2014 10:44:28 GMT

Thanks. I tried but there is no change if I use for other two expressions. Any help please?

Re: Static Min, Static Max, Static Step in bar chart?

arjunkrishnan — Thu, 03 Apr 2014 10:52:53 GMT

Hi Amelia,

Static Min -> Axis ->Start From

Static Max -> Axis->End From

Static Steps -> Axis -> Split with Num

Example

Static Min =0

Static Max=60

Static Steps=10

Static Steps===> Split Like That (0,10,20,30,40,50,60)

Regards by

ArjunKrish

Re: Static Min, Static Max, Static Step in bar chart?

crusader_ — Thu, 03 Apr 2014 11:13:02 GMT

When you add Second/ Third etc expression using 2 or more Dimensions Chart automatically become Stacked styled. Concerning static scale - the Chart will use properties set for first expression.

Please see attached file.

Re: Static Min, Static Max, Static Step in bar chart?

arjunkrishnan — Thu, 03 Apr 2014 11:31:16 GMT

Hi Amelia,

Pls Find My Attachment qvw ..

It will help for Requirement

Regards By Arjun

Re: Static Min, Static Max, Static Step in bar chart?

Naushad07 — Wed, 10 Jul 2019 07:42:43 GMT

I have a bar chart where my data varies from -26k to 22m. As of now, I am to see only values which are in millions. How can I use static min and max?