topic Re: Sheets in QlikView

Sheets

rathnam_qv — Sat, 27 Jul 2013 06:38:50 GMT

Hi all,

i have two buttons in my Sheet, if click on one button second button should activte, the first button should disabled

can any one help me...

Thanks in advance!!!!

Smiley

Re: Sheets

kaushiknsolanki — Sat, 27 Jul 2013 06:53:29 GMT

Hi,

There is no way a button can be made disabled, but you can try hide and show of the button.

Meaning on click of the button other button will be visible and vice versa.

For this you must add the expression under Layout Tab -> Conditional Show.

Regards,

Kaushik Solanki

Re: Sheets

rathnam_qv — Sat, 27 Jul 2013 13:41:03 GMT

Hi Kaushik,

thanks for Replay

i have two buttons one belons to one chart and another one belongs to 2nd chart,

if i clik on 1st button it should display first chart, the second button should not visible

if i select 2nd botton the related chart should display 1st button should not visible

Re: Sheets

nizamsha — Sat, 27 Jul 2013 15:58:27 GMT

i dnt knw adt the button but i tried in the text object if i click one text object mean it will disply the related chart wht i linked.. other text object and chat wll disabled

first create the variable like vshow and expression as 1

then in ur textobject go to action------>setvariable------------------>variablename---->vshow -->in value give -->-1--->

then go the chart in layout tab----->check the condition and write vshow =1

for another text object follow the same thng but instead of giving value--->1 give value--->2

same as chart

Re: Sheets

nagaiank — Sat, 27 Jul 2013 16:53:05 GMT

Did you try using the two objects in a container?

Re: Sheets

rustyfishbones — Sat, 27 Jul 2013 18:27:44 GMT

Here is a link to a video that will help

https://www.youtube.com/watch?v=xw3D2HnZAt0&feature=youtube_gdata_player

Re: Sheets

Kushal_Chawda — Sat, 27 Jul 2013 20:24:50 GMT

Hi,

Please find the attached application. may be help you.

Re: Sheets

Anonymous — Sun, 28 Jul 2013 01:32:05 GMT

Create a variable, let's name it vButton.
For the first button, add action vButton=0, and for the 2nd button, add action vButton=1.
To enable/disable - see "Enable condition" in the button properties. For the 1st button, set enable condition vButton=1, and for the 2nd button, set enable condition vButton=0.
Now, if the vButton is 1, the 1st button is enabled and the 2nd is disabled. Wehn you click it, vButton is set to 0, and the button gets disabled - but the 2nd button is enabled.

Certainly you can use the same variable to show charts or add any other actions to your buttons.

Regards,
Michael

Re: Sheets

kaushiknsolanki — Sun, 28 Jul 2013 06:47:58 GMT

Hi,

Dear what are you saying.

"if i clik on 1st button it should display first chart, the second button should not visible

if i select 2nd botton the related chart should display 1st button should not visible"

If your second button is not visible how will you click it.

Some how you have to make it visible to click right.

Think about it once.

Many people have given a good example, understand and utilize them.

Regards,

Kaushik Solanki

Re: Sheets

ngulliver — Mon, 29 Jul 2013 08:29:05 GMT

Hi, Smiley.

Steve Dark has written a blog on the different uses of buttons with some example code you can use.

Follow the link below:

http://www.quickintelligence.co.uk/qlikview-buttons/

Cheers,

Neil