topic Re: Making selections in two list boxes in QlikView

Making selections in two list boxes

ZoeM — Sat, 16 Nov 2024 02:54:58 GMT

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?

Re: Making selections in two list boxes

dplr-rn — Wed, 24 Jul 2019 16:05:22 GMT

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

Re: Making selections in two list boxes

ZoeM — Wed, 24 Jul 2019 16:17:16 GMT

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.

Re: Making selections in two list boxes

dplr-rn — Wed, 24 Jul 2019 16:24:50 GMT

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

Re: Making selections in two list boxes

ZoeM — Wed, 24 Jul 2019 16:26:35 GMT

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

Re: Making selections in two list boxes

dplr-rn — Wed, 24 Jul 2019 16:46:29 GMT

see attachd

Re: Making selections in two list boxes

ZoeM — Wed, 24 Jul 2019 18:41:05 GMT

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

Re: Making selections in two list boxes

dplr-rn — Wed, 24 Jul 2019 18:48:28 GMT

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

Re: Making selections in two list boxes

qliksus — Thu, 25 Jul 2019 05:29:06 GMT

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

Re: Making selections in two list boxes

ZoeM — Thu, 25 Jul 2019 13:14:19 GMT

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?