topic Re: Show/Hide values on line chart on button click in QlikView

Show/Hide values on line chart on button click

Wed, 25 Nov 2020 16:16:04 GMT

I have a line chart and what I am trying to do is to show/hide values for data points in the line chart when user check/uncheck a checkbox. How can I do this? Is it possible in QlikView 11?

Re: Show/Hide values on line chart on button click

antoniotiman — Sun, 28 Aug 2016 10:41:38 GMT

Hi Tony,

create Variable like vShowValue and

use Show Values option

Re: Show/Hide values on line chart on button click

sunny_talwar — Sun, 28 Aug 2016 10:49:18 GMT

Like this?

With check box not selected

With check box selected

Settings 1 -> Add a show value condition like this -> =If(GetSelectedCount(Dim) = 0, RowNo() = 0, 1=1)

Here Dim is a field created in the script like this

Dim:

LOAD * Inline [

Dim

Show Values

];

Settings 2 -> Uncheck 'Values on Data Points'

Re: Show/Hide values on line chart on button click

Sun, 28 Aug 2016 12:24:10 GMT

Your example is great! but I would like to do it using a variable and a text object, that is:

I have a variable, let's say, 'ShowValues', and I set this variable to 1 or 0 when user clicks on the text object, so when user click on it:

I set 'ShowValues' to 0 if current value of 'ShowValues' is 1 and I set background color for text box to white
I set 'ShowValues' to 1 if current value of 'ShowValues' is 0 and I set background color for text box to green

so in the text object properties, in actions tab, I have defined an action to set the variable "ShowValues" with value:

=If($(ShowValues)=1,0,1)

In order to check the value of 'ShowValues' variable I have created another text object and I set its text to:

=$(ShowValues)

but this shows: error in the expression. too complex,more than 100 levels nesting.

Finally in chart expression, I set definition for Show Value property as Antonio Mancini said to:

=ShowValues=1

but seems to not work.

Re: Show/Hide values on line chart on button click

antoniotiman — Sun, 28 Aug 2016 12:27:47 GMT

Have You unchecked

Value on Data Point for Your Expression ?

Re: Show/Hide values on line chart on button click

sunny_talwar — Sun, 28 Aug 2016 12:29:48 GMT

Try now

Re: Show/Hide values on line chart on button click

Sun, 28 Aug 2016 12:58:07 GMT

At the same time you, Sunny, was answering and providing a new example, I was solving it using a combination of both explanations, that indicated for Antonio Mancini and you, Sunny.

I have done the following (as you, Sunny, in your great example):

In the text object properties, in actions tab, I have defined an action to set the variable "ShowValues" with value:

=If(ShowValues=1,0,1)

instead of:

=If($(ShowValues)=1,0,1)

In order to check the value of 'ShowValues' variable I have created another text object and I set its text to:

=ShowValues

instead of:

=$(ShowValues)

And finally, in chart expression, I set definition for Show Value property as Antonio Mancini said to:

=ShowValues=1

Value on Data Point for expression was already unchecked.

So both have helped me a lot. Antonio Mancini by pointing me in the right direction at the beginning and you, Sunny, for your great detailed explanation through your magnific examples So both answers are correct but I have to choose one as correct... So as Sunny example is more detailed and complet and last one is what I want, I have choose Sunny answer as the correct.

Once more, thanks both for you great and quickly support.