Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
MuraliPrasath
Contributor III

Button to Change Customers

Hi,

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

Need Help!

Thanks,

Murali

1 Solution

Accepted Solutions
Highlighted
priyasawant
Contributor II

Re: Button to Change Customers

hi kindly create a variable vShow, and take 2 buttons

button.PNG

and set that variable on those buttons

button1.PNG

button2.PNG

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

button3.PNG

button4.PNG

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

button5.PNG

View solution in original post

9 Replies
Highlighted
MVP
MVP

Re: Button to Change Customers

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

Highlighted
MVP
MVP

Re: Button to Change Customers

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
MuraliPrasath
Contributor III

Re: Button to Change Customers

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

Highlighted
MVP
MVP

Re: Button to Change Customers

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
MuraliPrasath
Contributor III

Re: Button to Change Customers

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

Partner
Partner

Re: Button to Change Customers

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.

Highlighted
priyasawant
Contributor II

Re: Button to Change Customers

hi kindly create a variable vShow, and take 2 buttons

button.PNG

and set that variable on those buttons

button1.PNG

button2.PNG

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

button3.PNG

button4.PNG

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

button5.PNG

View solution in original post

Highlighted
Not applicable

Re: Button to Change Customers

can you share sample ?

Highlighted
Partner
Partner

Re: Button to Change Customers

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