Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
ZoeM
Contributor III

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
Partner
Partner

Re: Making selections in two list boxes

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
Partner
Partner

Re: Making selections in two list boxes

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

ZoeM
Contributor III

Re: Making selections in two list boxes

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. 

Partner
Partner

Re: Making selections in two list boxes

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

ZoeM
Contributor III

Re: Making selections in two list boxes

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

Partner
Partner

Re: Making selections in two list boxes

see attachd

ZoeM
Contributor III

Re: Making selections in two list boxes

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

Partner
Partner

Re: Making selections in two list boxes

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
Valued Contributor II

Re: Making selections in two list boxes

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

ZoeM
Contributor III

Re: Making selections in two list boxes

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?