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: 
ZoeM
Specialist
Specialist

Making selections in two list boxes

Hi Community.

I have two list boxes in my dashboard, Issue Type and Issue Description. 

I am trying to select 'Electrical' as the issue type and then search and also include everything that has electrical in it from Issue Description, even though the issue Type is something else so that I have full picture of everything affecting electrical, even though they fall in a different issue type. 

Electrical alone is three selections and searching for descriptions with "Electrical" in them produces 5 results.

Is this possible in the tool?

Labels (2)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Not possible directly from filters.

But it is possible through set analysis see attached. have created a new chart where if only 1 issue type is selected it gives values under that type and also with text descriptions. May not be the full solution what you want to achieve but should help nudge you in right direction

 

View solution in original post

9 Replies
dplr-rn
Partner - Master III
Partner - Master III

Not possible directly from filters.

But it is possible through set analysis see attached. have created a new chart where if only 1 issue type is selected it gives values under that type and also with text descriptions. May not be the full solution what you want to achieve but should help nudge you in right direction

 

ZoeM
Specialist
Specialist
Author

This is a powerful workaround Dilipranjith.

I think it may solve the issue in the interim, but probably not the long run, especially if the field options in one selection box are named differently.

Im just thinking out loud as to how it is done in Excel, you download two reports for the data you want to combine, create a unique key, delete duplicated keys and voila! Such a long process I know.

Thanks my friend, let me try this out. 

Is it possible to have the second part of your equation be a free field where you can add search criteria? So say we follow the condition and say if I select electrical as issue type and then i also want to make sure that interference is the ext level or maybe electrical or it might be something else? I feel hard coding it might be challenging for the dynamic capability needed. 

dplr-rn
Partner - Master III
Partner - Master III

You can have an input box and assign that to a variable. And use that variable in the set analysis 

ZoeM
Specialist
Specialist
Author

Thats what Im talking about. Can you show an example using the one you sent me?

dplr-rn
Partner - Master III
Partner - Master III

see attachd

ZoeM
Specialist
Specialist
Author

I dont seem to get the same result as the initial table created. 

dplr-rn
Partner - Master III
Partner - Master III

Which table?

this new table takes the variable entered and searches it on Issue Description field

 

Count({<[Issue Description]={"*$(=vSearchDescription)*"}>
}[Issue Description])

if you want it to search on Issue and Issue Description

try below expression instead (+ is for or condition so below expression return values matching Description or Type)

Count({<[Issue Description]={"*$(=vSearchDescription)*"}>

+<[Issue Type]={"*$(=vSearchDescription)*"}>
}[Issue Description])

 

read up a bit more on set analysis you should be able to take it forward from here. There are some great cheap udemy courses too

qliksus
Specialist II
Specialist II

Use search object which search for  a particular word in the whole document and allows you to make selection as well

ZoeM
Specialist
Specialist
Author

I dont know why I forgot about this option Qliksus. 

However, when I create my search object, I typed in the phrase I want and I see the results but when I hit ENTER to select all results the system does not allow me. 

Is this a glitch?