Button to Change Customers

[MuraliPrasath]

Hi,

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

Need Help!

Thanks,

Murali

[tresesco]

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

[jonathandienst]

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

[MuraliPrasath]

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

[jonathandienst]

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.

[MuraliPrasath]

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

[marioglasmv]

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.

[priyasawant · Accepted solution]

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

[#9]

can you share sample ?

[ngulliver]

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