Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
May be search like this for exact matches
("xyz")
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?
You should be able to search like this
("Name1"|"Name2"|"Name3"|.....)
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 |
a | h | j |
b | k | y |
c | l | f |
d | i | g |
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
Table:
LOAD name1,
name2,
name3
FROM ....;
LinkTable:
LOAD name1 as Name,
'name1' as Flag
Resident Table;
Concatenate(LinkTable)
LOAD name2 as Name,
'name2' as Flag
Resident Table;
Concatenate(LinkTable)
LOAD name3 as Name,
'name3' as Flag
Resident Table;
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
To see them all in one, I think you will have to modify your script... May be some one else might have other ideas here