for exam i have 3 cols level 1,level2,level3 ,. when i search for name xyz , my search value might be listed in colq,col2 or col 3 search should look up for that value and allow me to filter the value.
is there a way to achieve this?
thanks sunny, the search value could be any thing user wants, it can be xyz or abc .
I have 10 name level columns, I need to bring all these to one col (like a union) . what should be my union expression to use in the filter pan?
Apologies Sunny. I should have put my ask in detail and in correct format .
I have 3 cols like this and lets say all the alphabets are the values in that . I have to provide a filter option to the users, where they can search any alphabet and can select it to filter on that. I would like to use filter pan in qlik sense visualizations.
|name 1||name 2||name 3|
In the filer dimension expression i used the code you provided ="[JO HM Level1]"|"[JO HM Level2]"|"[JO HM Level3]" , it says invalid dimension.
I would create a script like this
LOAD name1 as Name,
'name1' as Flag
LOAD name2 as Name,
'name2' as Flag
LOAD name3 as Name,
'name3' as Flag
Once you do this, make a search on the name field and all your linked name1, name2, and name3 will be selected
thankyou- other than writing a scrip to create my custom data item is there is a front end solution where I an write a my set expression ?
Are you looking do this for a particular chart? or are you looking to do this to select the possible options in list boxes for the three name? A sample file might help us help you better here to understand what exactly are you trying to do