how to get standard line in bar chart in qlikview?

[udaya_kumar]

Hi...

Can i get any idea that how to get a cut off straight line in bar chart in qlikview?

but the line should be dynamic.

i have attached the screenshot of the chart. i want to get that green line in the bar chart as shown in the screenshot.

Can anyone help me in this?

Thanks in advance.

[swuehl]

Please have a look at the reference line in presentation tab of your chart properties.

Hope this helps,

Stefan

[udaya_kumar]

Hi stefan,

Thanks for the reply,

i checked it there, but the Continuous-x option(checkbox) is disable in Reference line.

how to enable that option?

[swuehl]

You will need to set x-axis to continouus in axis tab first.

But do you need to use a continouus axis? In above sample, you probably don't, but maybe your real app looks different? Please note that as far as I see, your attached image shows a chart rotated by 90° (check out style tab for that) so x-axis is vertical.

Hope this helps,

Stefan

[udaya_kumar]

thanks for the reply,

i will try it out.

And can you help in one more issue?

i want to show and hide table on clicking button in qlikview, how can we do that?

[swuehl]

You could set a Variable to 0 resp. 1 by clicking the button and then use a condition show (check out layout tab of the objects properties).

Like using an action set Variable on button trigger with expression:

=if(vShow=0,1,0)

and I think

=vShow

should be enough in the show condition expression.

Hope this helps,

Stefan

[udaya_kumar]

thanks for the reply,

i will try it out

[swuehl]

Two things I forgot:

You will need to declare the Variable vShow in Variabel Overview first. And look out for the Set Variable action under Action Type "External".

[udaya_kumar]

thanks for the reply,

i will try it out, and one more question.

Is it possible to show the table and move the other controls down?

Requirement is, Like i will not be giving place for the table to display, whenever i click on the button, it should move all the controls down and show the table in that space, is it possible to do in qlikview?

[swuehl]

Not sure, I think I read some post about re-layouting using macros, but I think you should open a new thread for this requirement.