Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please have a look at the reference line in presentation tab of your chart properties.
Hope this helps,
Stefan
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?
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
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?
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
thanks for the reply,
i will try it out
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".
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?
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.