topic Re: Re: Button logic in QlikView

Button logic

Thu, 02 Jan 2014 13:03:09 GMT

So Dear All,

I want to select 2 column having data from different excel sheet to be selected on a single button..

Header 2
AA
CC
DD

Header 2
AA
XX
EE

So I want to select AA , CC from first table and AA, XX from second one on a single selection of button...

Plz reply ....

Re: Button logic

Miguel_Angel_Baeyens — Thu, 02 Jan 2014 13:06:52 GMT

Hi,

Use an action in a button object to Select in Field and set the values as

(AA|CC)

(AA|XX)

To select several values.

Miguel

Re: Button logic

Fri, 03 Jan 2014 06:40:16 GMT

Dear All,

I want to select to select Admin,Agra,Amritsar on both Market1 and Market2 column on a single click of HR button as shown in Attachment...

Plz tell me how to do....

Re: Re: Button logic

sundarakumar — Fri, 03 Jan 2014 06:55:06 GMT

Pls share the sample source file that you have used. I think the problem is you are using market 1 as market2.

Try renaming market 1 to something like mar1 and replace it in the attached qvw, if it doesnt work, pls share the source.

-Sundar

Re: Button logic

qvwarning — Fri, 03 Jan 2014 07:03:33 GMT

Hi Rahul,

try: First action in button object -> Select in field Market 1 : (Admin|Agra|Amritsar)

second action -> Select in field Market2 : (Admin|Agra|Amritsar)

Andreas

Re: Re: Button logic

tresB — Fri, 03 Jan 2014 07:09:44 GMT

PFA

Re: Re: Button logic

Fri, 03 Jan 2014 07:34:50 GMT

Hi Rahul ,

Click on Button HR in application it will select those three fields required ...

Go Actions tab in properties of button check out how it works..

PFA ..

Rgards,

Koti Reddy

Re: Re: Re: Button logic

Fri, 03 Jan 2014 08:06:14 GMT

Dear All thanks for the reply... but I don't want to select Admin,Agra,Amritsar on button selection.. I want to show them active when I select ADMIN BUTTON... as shown in attachment...

there are no link between the two sheet and I have to create a button on that both column data will active as it active on listbox...

Re: Re: Re: Re: Button logic

Fri, 03 Jan 2014 08:40:57 GMT

Hi Rahul ,

In the same application..

Go to button properties ...

Actions Select in Field-> location

Fieldvalue -> ADMIN

It will automatically Shown them as active even if u delete location list box .

PFA ..

Regards,

Koti Reddy

Re: Re: Re: Re: Re: Button logic

Fri, 03 Jan 2014 09:49:18 GMT

My problem is that I have to make a button on which I got the same result which u shown but there are no link like (location) in the two sheet....as show in attachment...

Re: Button logic

Fri, 03 Jan 2014 10:18:27 GMT

Hi Rahul ,

As per my knowledge ,

you have select the related field to make those value Active in the listbox. I think there is not any other option to activate those Listbox values..\

If u want Shown Active of two list box values U have select two related fileds make selectio in Action tab..

Regards,

koti Reddy