topic Re: Hiding Reference Lines in QlikView

Hiding Reference Lines

Thu, 30 Apr 2015 12:20:39 GMT

Is there a way to create a check box that you can turn on and off a reference line on a chart?

~Norman Rea

Re: Hiding Reference Lines

datanibbler — Thu, 30 Apr 2015 12:22:32 GMT

Hi,

sure there is. You can wrap the expression for the line inside an IF_expression making it dependent on the value of a variable.

I would advise you to create a "development_variable" that you can use in any app you create and that you can toggle, thus turning such things on or off at will.

HTH

Re: Hiding Reference Lines

Thu, 30 Apr 2015 12:24:22 GMT

you have some example code for me to understand?

~Norm

Re: Hiding Reference Lines

buzzy996 — Thu, 30 Apr 2015 12:25:56 GMT

ur looking for this?

Re: Hiding Reference Lines

datanibbler — Thu, 30 Apr 2015 12:27:19 GMT

Well, just use the usual

>> SET v_Dev = 1 <<

to initialize the variable.

Then you can wrap any expression in an IF_clause like

>> = IF(v_Dev = 1,

) <<

You can also make the visibility of any object dependent on that variable. And you can add a button with the expression (to set a variable_value) >> = v_Dev * -1 << - that way, it will be either 1 or -1 and you can toggle it easily.

Re: Hiding Reference Lines

sunny_talwar — Thu, 30 Apr 2015 12:27:47 GMT

Hahahaha you are right. It makes me feel so stupid that I thought it was not possible,

Best,

Sunny

Re: Hiding Reference Lines

robert_mika — Thu, 30 Apr 2015 12:56:35 GMT

..or more advance way.

Add this to Edit Module window and add to buttons

One will create line in your chart the other will remove it

(Change the bit in Green to your values)

sub AddRef

set chart = ActiveDocument.GetSheetobject("CH01")

col = ActiveDocument.GetApplication.GetSolidColorArea(255,0,0) 'red

chart.AddRefLine "50",2,col 'red at 50 on primary y

set p = chart.GetProperties

set rl = p.ChartProperties.RefLines.Item(0)

rl.Style = 0 'solid

chart.SetProperties p

End sub

Sub RemoveRef

set Graph = ActiveDocument.GetSheetObject("CH01")

Graph.RemoveRefLine 0

End sub

Re: Hiding Reference Lines

Thu, 30 Apr 2015 13:09:08 GMT

There is standard functionality to conditionally show/hide refrence lines, so I really wouldn't recommend doing this via a macro.

Please see attached

Hope that helps

Joe

Re: Hiding Reference Lines

buzzy996 — Thu, 30 Apr 2015 13:16:32 GMT

try this way also,

Re: Hiding Reference Lines

Thu, 30 Apr 2015 13:31:32 GMT

Where did you define you variable

Re: Hiding Reference Lines

Thu, 30 Apr 2015 13:40:17 GMT

I just created it in the UI under variable overview, but you ideally want to create this in the script

SET vshow = 1;

in the script editor

Joe