Zooming in options

[#1]

Hi all,

I have a bar chart with multiple bars and I would like to show only the values on data point when zoomed in so that they won't overlap.

[nagireddy_qv]

Hi,

In your chart, first uncheck the 'Values on Data Points' option. (Right Click on the Chart, Properties / "Expressions" Tab).
Then, in the "Expressions" Tab, click on the "+" symbol near the expressions you want to hide labels.

All you need to do is to define a expression of the "Show Value" attribute expression.
When the value of this expression is equal to Zero, no value labels are displayed on the chart, in other cases, values are displayed.

For example if you enter the following expressions :

=(GetSelectedCount([Date])<5)

You will only display value when less than 4 dates are selected

Hope this helps.

[vikasmahajan]

Trigger the below macro in

Sub FitZoomToWindow 

ActiveDocument.GetApplication.WaitForIdle 

ActiveDocument.ActiveSheet.FItZoomToWindow 

End Sub 

Settings -> Document Properties -> Triggers -> On open -> Add Action -> Add -> External -> Run Macro -> Give Macro Name (FitZoomToWindow)

Before that paste the above macro code in the Edit Module window (Ctrl + M).

For some other sample macros check the link below

Useful Qlikview Macros

HTH

Vikas