topic Re: Show/hide Value Data Points in the chart based on a button in QlikView

Show/hide Value Data Points in the chart based on a button

Mon, 21 May 2012 13:26:48 GMT

Goal:

Show/hide Value Data Points in the chart based on a button

Problem:

I don't know how to do it so I gonna need som help.

Show/hide Value Data Points in the chart based on a button

Nicole-Smith — Mon, 21 May 2012 17:00:30 GMT

You can have two charts: one that shows the values on data points and another that does not. Overlay them, and use a variable in the Show/Hide condition (on the layout tab) for each chart. Have the button set the variable to the appropriate value for which chart should show. I'm not sure if there is a way to check or uncheck the box by using a macro, but I'm thinking there isn't...

Re: Show/hide Value Data Points in the chart based on a button

Mon, 21 May 2012 21:48:57 GMT

Hi Akirajit

Actually if you expand the expression list there is an option to enter an expression under the heading "Show Value".

Start by expanding the expression you are working with (as per screen shot) and click on the box marked "show value"

In the definition, enter an expression that evaluates to 1 to show the values and 0 to remove them. This can be a reference to a variable that is set by clicking a button.

One warning though: you need "values on data points" unchecked. If it becomes checked it overrides the expression.

Regards,

Erica

Re: Show/hide Value Data Points in the chart based on a button

Fri, 28 Feb 2014 17:28:08 GMT

if i use show value option..

the format of the expression is changed

Re: Show/hide Value Data Points in the chart based on a button

Sat, 01 Mar 2014 08:46:26 GMT

What happens to the format Raja?