Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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.
You can have an input box and assign that to a variable. And use that variable in the set analysis
Thats what Im talking about. Can you show an example using the one you sent me?
see attachd
I dont seem to get the same result as the initial table created.
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
Use search object which search for a particular word in the whole document and allows you to make selection as well
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?