Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
homersimpson
Contributor III

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
Valued Contributor III

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

Hi,

Let me know if the attached helps.

Capture.PNG

sinanozdemir
Valued Contributor III

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

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.