Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Create a special filter - measure contains text of selected filter value

Hi,

i don´t now if is possible.

  • I want to make filter field like "Domain".
  • This Filter should have 3 values:
    1. www.abc.com
    2. www.def.com
    3. www.ghi.com
  • This 3 values don´t exist in the database.
  • In the database exist the field "url". It has values like
    1. www.abc.com/dir/site1
    2. www.abc.com/dir/site2
    3. www.def.com/dir/site1
    4. www.ghi.com/dir/site1
    5. etc.
  • If i select a domain in the filter field, it should shows only data from the field "url" in the diagramm wich match the selected filter in domain.
  • Example, www.def.com is selected in filter "Domain", the diagramm shows only the data for the url www.def.com/dir/site1

Is it possible, if yes, how can i do that?

regards

Fritz

2 Replies
sinanozdemir
Specialist III
Specialist III

Hi,

Let me know if the attached helps.

Capture.PNG

sinanozdemir
Specialist III
Specialist III

In case you cannot open the app, here is the expression in the list box:

Capture.PNG

You can pick "Expression" from the field drop-down and use SubField() function to generate the list box.