topic Create a button to minimize and maximise graphs in QlikView

Create a button to minimize and maximise graphs

Tue, 31 Aug 2010 09:23:13 GMT

I am after a button that will minimise the graphs that are not applicable and will maximise the graphs which are applicable.

Create a button to minimize and maximise graphs

Or — Tue, 31 Aug 2010 09:34:47 GMT

This is normally achieved by using a variable. Your button(s) will change the variable's value. In each graph's 'Show'/Conditional (under the Layout tab in object properties), use a condition along the lines of myVariable = X. Your variable might start off at 0, with buttons to change it to 1, 2, or 3 - each showing a different group of objects with myVariable = 1, myVariable = 2, or myVariable = 3 in their 'Show' box

Good luck.

Create a button to minimize and maximise graphs

Tue, 31 Aug 2010 09:40:56 GMT

Hi,

Go to tools---> Edit module

Copy this piece of code

Sub ShowPremium

set cs = ActiveDocument.GetSheetObject("CH73") // object id is put inside the braces

cs.Minimize

set cs = ActiveDocument.GetSheetObject("CH74")

cs.Minimize

set cs = ActiveDocument.GetSheetObject("CH66")

cs.Restore

set cs = ActiveDocument.GetSheetObject("CH67")

cs.Restore

set cs = ActiveDocument.GetSheetObject("CH68")

cs.Restore

set cs = ActiveDocument.GetSheetObject("CH69")

cs.Restore

End Sub

Create a button object and in the macro , give macro name as ShowPremium

Hope this helps,

Sam