topic Static Min and Max Axes in QlikView

Static Min and Max Axes

Sat, 24 Dec 2011 12:40:50 GMT

Hi all,

how to change the axes of the barchart, it should change according the bars displayed in chart for each DefectNameShort.

i.e; if the max barchart count is 315, then the StaticMax Axes should be 315, and

if the min barchart count is 10, then the StaticMax Axes should be 0

plese see the attached application.

How can i work on this ?

Regards

Venkat

Re: Static Min and Max Axes

IAMDV — Sun, 25 Dec 2011 13:25:26 GMT

Hi Venkat,

Have you tried using the expression in the Static Min and Static Max expression editor? You need to put "=" at the beginning to make this as expression.

I hope this helps! Let me know if you still have problems.

Cheers - DV

Re: Static Min and Max Axes

Mon, 26 Dec 2011 07:17:05 GMT

HI DV,

I tried using the expression in Static Min and Max starting with "=" sign , but i can't find the what should be the correct expression to satisfy my requirement.

EX: i.e; the min should start from 0 and max should be the highest bar value in the chart.

Can you please provide an expresssion for static max, that which should statisfies the above example requirement.

Thanks

Regrads

Venkat.

Re: Static Min and Max Axes

SunilChauhan — Mon, 26 Dec 2011 07:30:40 GMT

see the attched file hope this helps

Re: Static Min and Max Axes

Mon, 26 Dec 2011 08:25:04 GMT

Hi Sunil,

Thanks, Yes this is what i expecting.

Can you tell me where the changes had been done by you in scatter chart ?

I tried it but i can't notice the difference.

Regards

Venkat.

Static Min and Max Axes

SunilChauhan — Mon, 26 Dec 2011 08:32:53 GMT

supress null on second dimension

then uncheck all the check box in Axes tab in chart properties

Re: Static Min and Max Axes

Mon, 26 Dec 2011 08:57:39 GMT

Thank you soo much Sunil Chauhan.

Regards

Venkat