Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Button logic

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 ....

10 Replies
Miguel_Angel_Baeyens

Hi,

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

(AA|CC)

or

(AA|XX)

To select several values.

Miguel

Not applicable
Author

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....

sundarakumar
Specialist II
Specialist II

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

qvwarning
Creator
Creator

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

tresesco
MVP
MVP

PFA

Not applicable
Author

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

Not applicable
Author

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...

Not applicable
Author

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

Not applicable
Author

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...