topic Re: button? in QlikView

button?

Anonymous — Mon, 29 Sep 2014 07:39:04 GMT

i want give multiple action for one button? is it possible?

ex: if i click on button then should display bar chart and when i click on same button second time then it should clear all selections ?

Re: button?

sagarkharpude — Mon, 29 Sep 2014 07:43:33 GMT

It's possible but you need to add two different action for that.

Re: button?

jyothish8807 — Mon, 29 Sep 2014 07:43:57 GMT

Hi Qlik777,

You have to write a macro for that and run that macro through that button.

Regards

Re: button?

ngulliver — Mon, 29 Sep 2014 07:45:35 GMT

Hi,

Have a look at http://www.quickintelligence.co.uk/qlikview-buttons/

This blog has an explanation with working examples.

Cheers,
Neil

Re: button?

Anonymous — Mon, 29 Sep 2014 07:50:19 GMT

with out macro we can't?

Re: button?

maleksafa — Mon, 29 Sep 2014 07:51:23 GMT

create a variable call it vbuttonselection initialized to 0

when you first click on the button, on the first line set the variable to 1 if the value is 0 and to 2 if the value is 1: if(vbuttonselection = 0,1,2)

on the second line put your desired action to display the chart, with the condition on the vbuttonselection = 1, if(vbuttonselection=1,'CH23') (CH23 being the chart you want to display).

on the third line put your desired action to remove selection, with the condition on the vbuttonselection =2.

so the first time you click it will set the variable to 1 and will execute the second line (show chart), if you click again it will evaluate the variable and set it to 2 so the second line will not be executed and the third line to clear the selection will then be executed.

Re: button?

sushil353 — Mon, 29 Sep 2014 07:53:44 GMT

Hi,

You can achieve this by using a variable.

create a variable say vButton and assign a value say 0

in button add action> set variable > and set the values as not(vButton):

now in your bar chart>layout> show condtional : =$(vButton)

and for clearing selection add trigger Settings>document properties>trigger> Variable Event Trigger> On Input > if($(vButton)=0,1,0)

HTH

Sushil

Re: button?

Anonymous — Mon, 29 Sep 2014 07:56:00 GMT

It is possible. You just have to create a variable and modify the var value at each click on the button. For that, go to button properties, actions, add, and select modify variable. Fill in the name and the value: =mod($(vVar)+1, 3) So, you will have a variable getting values from 0 to 2.

Now you go to the different objects you want to show/hide and put the condition

=if($(vVar)=0, 1, 0) in the objects you want to show without click

=if($(vVar)=1, 1, 0) in the objects you want to show when 1 click

=if($(vVar)=2, 1, 0) in the objects you want to show when second click

Hope it helps.