Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
maxronny
Contributor III
Contributor III

select data in two fields

dear all,

i have this question:

suppliercodedateamountnumberselect1select2
146554031/12/201910011red 
25642330/01/202020022 red
3321329/02/202030033 red
489730/03/202040044blu 
53232129/04/202050055 

blu

 

how can i select "red" in different fields? my goal is to have this issue by selecting "red"

suppliercodedateamountnumberselect1select2
146554031/12/201910011red 
25642330/01/202020022 red
3321329/02/202030033 red

 

the other problem is that i cannot modify the script. so can i create, for example, a filter?

 

thank you for the attention.

1 Solution

Accepted Solutions
maxronny
Contributor III
Contributor III
Author

dear Vamsee, thank you very much for your answer. my problem is a little more complicated. see the table below

suppliercodedateamountnumberselect1select2
146554031/12/201910011aa 
25642330/01/202020022 aa
3321329/02/202030033 ba
489730/03/202040044ab 
53232129/04/202050055 cc
65231/12/201960066dd 
743530/01/202070077 aa
823529/02/202080088 ba
93453430/03/202090099ab 
10567529/04/20201000110 cc
118776831/12/20191100121aa 
129830/01/20201200132 aa
13529/02/20201300143 ba
143330/03/20201400154ab 
154545429/04/20201500165 cc
16731/12/20191600176aa 
178857730/01/20201700187 dd
1867529/02/20201800198 ba
1945630/03/20201900209ab 
205629/04/20202000220 da
216831/12/20192100231da 
228001/01/20202200242aa 
239202/01/20202300253 aa
2410403/01/20202400264 ba
2511604/01/20202500275ab 
2612805/01/20202600286 cc
2714006/01/20202700297aa 
2815207/01/20202800308 dd
2916408/01/20202900319 ba
3017609/01/20203000330ab 
3118810/01/20203100341 da
3220011/01/20203200352da 
3321212/01/20203300363aa 
3422413/01/20203400374 aa
3523614/01/20203500385 ba
3624815/01/20203600396ab 
3726016/01/20203700407 cc
3827217/01/20203800418aa 
3928418/01/20203900429 dd
4029619/01/20204000440 ba
4130820/01/20204100451ab 
4232021/01/20204200462 db
4333222/01/20204300473da 
4434423/01/20204400484aa 
4535624/01/20204500495 aa
4636825/01/20204600506 da
4738026/01/20204700517db 
4839227/01/20204800528 cc
4940428/01/20204900539aa 
5041629/01/20205000550 db
5142830/01/20205100561 ba
5244031/01/20205200572ab 
5345201/02/20205300583 da
5446402/02/20205400594db 
5547603/02/20205500605aa 
5648804/02/20205600616 db
5750005/02/20205700627 ba
5851206/02/20205800638ab 
5952407/02/20205900649 cc
6053608/02/20206000660db 
6154809/02/20206100671 dd
6256010/02/20206200682 ba
6357211/02/20206300693ab 
6458412/02/20206400704 da
6559613/02/20206500715da 
6660814/02/20206600726aa 
6762015/02/20206700737 aa
6863216/02/20206800748 db
6964417/02/20206900759ab 
7065618/02/20207000770 cc
7166819/02/20207100781aa 
7268020/02/20207200792 db
7369221/02/20207300803 ba
7470422/02/20207400814ab 
7571623/02/20207500825 da

 

my goal is to get a "filter" where i can select, for example, all rows "db" in fields "select1" end "select2" in the same time:

suppliercodedateamountnumberselect1select2
4232021/01/20204200462 db
4738026/01/20204700517db 
5041629/01/20205000550 db
5446402/02/20205400594db 
5648804/02/20205600616 db
6053608/02/20206000660db 
6863216/02/20206800748 db
7268020/02/20207200792 db

 

"db" is an example, i could select "da" or any other...

Thank you averyone for your support.

Massimo.

View solution in original post

2 Replies
vamsee
Specialist
Specialist

Maybe try creating a list box with the following condition

=if(select1='red' or select2='red','Red','Others')

Attached is the sample app 

maxronny
Contributor III
Contributor III
Author

dear Vamsee, thank you very much for your answer. my problem is a little more complicated. see the table below

suppliercodedateamountnumberselect1select2
146554031/12/201910011aa 
25642330/01/202020022 aa
3321329/02/202030033 ba
489730/03/202040044ab 
53232129/04/202050055 cc
65231/12/201960066dd 
743530/01/202070077 aa
823529/02/202080088 ba
93453430/03/202090099ab 
10567529/04/20201000110 cc
118776831/12/20191100121aa 
129830/01/20201200132 aa
13529/02/20201300143 ba
143330/03/20201400154ab 
154545429/04/20201500165 cc
16731/12/20191600176aa 
178857730/01/20201700187 dd
1867529/02/20201800198 ba
1945630/03/20201900209ab 
205629/04/20202000220 da
216831/12/20192100231da 
228001/01/20202200242aa 
239202/01/20202300253 aa
2410403/01/20202400264 ba
2511604/01/20202500275ab 
2612805/01/20202600286 cc
2714006/01/20202700297aa 
2815207/01/20202800308 dd
2916408/01/20202900319 ba
3017609/01/20203000330ab 
3118810/01/20203100341 da
3220011/01/20203200352da 
3321212/01/20203300363aa 
3422413/01/20203400374 aa
3523614/01/20203500385 ba
3624815/01/20203600396ab 
3726016/01/20203700407 cc
3827217/01/20203800418aa 
3928418/01/20203900429 dd
4029619/01/20204000440 ba
4130820/01/20204100451ab 
4232021/01/20204200462 db
4333222/01/20204300473da 
4434423/01/20204400484aa 
4535624/01/20204500495 aa
4636825/01/20204600506 da
4738026/01/20204700517db 
4839227/01/20204800528 cc
4940428/01/20204900539aa 
5041629/01/20205000550 db
5142830/01/20205100561 ba
5244031/01/20205200572ab 
5345201/02/20205300583 da
5446402/02/20205400594db 
5547603/02/20205500605aa 
5648804/02/20205600616 db
5750005/02/20205700627 ba
5851206/02/20205800638ab 
5952407/02/20205900649 cc
6053608/02/20206000660db 
6154809/02/20206100671 dd
6256010/02/20206200682 ba
6357211/02/20206300693ab 
6458412/02/20206400704 da
6559613/02/20206500715da 
6660814/02/20206600726aa 
6762015/02/20206700737 aa
6863216/02/20206800748 db
6964417/02/20206900759ab 
7065618/02/20207000770 cc
7166819/02/20207100781aa 
7268020/02/20207200792 db
7369221/02/20207300803 ba
7470422/02/20207400814ab 
7571623/02/20207500825 da

 

my goal is to get a "filter" where i can select, for example, all rows "db" in fields "select1" end "select2" in the same time:

suppliercodedateamountnumberselect1select2
4232021/01/20204200462 db
4738026/01/20204700517db 
5041629/01/20205000550 db
5446402/02/20205400594db 
5648804/02/20205600616 db
6053608/02/20206000660db 
6863216/02/20206800748 db
7268020/02/20207200792 db

 

"db" is an example, i could select "da" or any other...

Thank you averyone for your support.

Massimo.