topic Re: Button to Change Customers in QlikView

Button to Change Customers

MuraliPrasath — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have two fields respectively CustomerA and CustomerB. I need a button to change the customers on dashboard.

Need Help!

Thanks,

Murali

Re: Button to Change Customers

tresB — Wed, 01 Mar 2017 05:06:59 GMT

Try to share a sample qvw and state expected output in more detail.

Re: Button to Change Customers

jonathandienst — Wed, 01 Mar 2017 05:20:54 GMT

Please provide more details about what you are trying to achieve. What do you mean by change? Are the customer fields related? Do you want to do this in a chart or table, or in list box(es)?

I suggest that you supply a sample qvw file with clear instructions about what the required result(s).

Re: Button to Change Customers

MuraliPrasath — Wed, 01 Mar 2017 05:47:01 GMT

I have two list boxes CustomerA and CustomerB. I need one button to select all the values in CustomerA list box or CustomerB list box.

-Murali

Re: Button to Change Customers

jonathandienst — Wed, 01 Mar 2017 05:56:55 GMT

Unfortunately that makes your requirements no clearer. If you cannot describe clearly in more detail what you need or provide a sample to illustrate, then you are unlikely to get much help.

Re: Button to Change Customers

MuraliPrasath — Wed, 01 Mar 2017 06:00:25 GMT

Thanks Jonathan, I will come back with more detail requirement.

Re: Button to Change Customers

marioglasmv — Wed, 01 Mar 2017 06:48:54 GMT

It is not completly clear what you want to do but you can put a button on your sheet and set an action.

Choose the option Select in field.

In the field option you can put the name (CustomerA or CustomerB)

In search string you can put the following:

='(' & CONCAT({1} CustomerA, '|') & ')'

When you click on the button it will select all the customers in CustomersA.

Maybe you have to add some extra actions to clear some fields (if necessary) depending on your qvw.

Re: Button to Change Customers

priyasawant — Wed, 01 Mar 2017 07:03:22 GMT

hi kindly create a variable vShow, and take 2 buttons

and set that variable on those buttons

And take the fields in the list box --> then in layout tab of that list box write a if condition

and then If you select Customer A button then list of Customer A will be displayed and vice-versa

Re: Button to Change Customers

Wed, 01 Mar 2017 07:12:34 GMT

can you share sample ?

Re: Button to Change Customers

ngulliver — Wed, 22 Mar 2017 16:07:11 GMT

Priyanka's explanation should be sufficient but if you want to know more about creating and using buttons have a look at this blog post:

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

Cheers,

Neil