topic Re: Zooming in options in QlikView

Zooming in options

Mon, 14 Mar 2016 21:38:48 GMT

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.

Re: Zooming in options

nagireddy_qv — Mon, 14 Mar 2016 21:46:21 GMT

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.

Re: Zooming in options

vikasmahajan — Tue, 15 Mar 2016 06:13:46 GMT

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