topic Re: Creating a Button in QlikView

Creating a Button

Tue, 27 Jan 2015 20:54:35 GMT

if i have a simple excel file listing like:

SKU SUPPLIER

12345 A

45678 A

23456 B

55678 A

How do i create a button to only show SKU's that are associated with supplier A?

Thanks for your help!

sunny_talwar — Tue, 27 Jan 2015 21:15:10 GMT

Is this what you are looking for? PFA

Best,

maxgro — Tue, 27 Jan 2015 21:18:52 GMT

see image, add an action to the button

rwunderlich — Tue, 27 Jan 2015 21:19:24 GMT

Do you want to select SUPPLIER=A or select SKU's associated with SUPPLIER A?

To select SKUs associated with SUPPLIER A, use Select in Field as the Action.

Field: SKU

Search String: ='=SUPPLIER=' & chr(39) & 'A' & chr(39)

The search string is a bit awkward because of needing to get the quotes in there.

-Rob