topic Re: How to create context filters? in QlikView

How to create context filters?

Wed, 25 Nov 2020 16:16:04 GMT

I have 2 filters Continent and Country.

My data is like this:

Continent Country

Asia China

Asia Japan

Asia Malaysia

Europe Germany

Europe Netherlands

I am creating filters as list boxes but when i apply first filter of Continent, I want country filter to only give option of the countries which are in that particular continent, eg: If Asia is selected then Country filter should not have option of Germany and Netherlands.

Re: How to create context filters?

ziadm — Mon, 20 Mar 2017 18:33:03 GMT

if these two field in the same table or related table by a Country as key then selecting Continent will filter only countries in in the selected continent. This is the associative experience of Qlik.

Re: How to create context filters?

Mon, 20 Mar 2017 18:51:24 GMT

Hello Ziad,

Thank you so much for your reply. The problem I am facing is that both the filters are in different states. So, they are not filtering that way.

Re: How to create context filters?

ziadm — Mon, 20 Mar 2017 18:59:30 GMT

Are you using Alternate State ?

Please pass a sample Data ...

Re: How to create context filters?

marcus_sommer — Mon, 20 Mar 2017 19:22:54 GMT

There is an option within the listbox properties in tab general to hide excluded values. Another possibility would be to use a listbox-expression like: aggr(only(Country),Country).

- Marcus

Re: How to create context filters?

Mon, 20 Mar 2017 19:25:13 GMT

Hello Marcus,

Thank you so much for your reply? Does a search object also have same property to hide excluded values?

Re: How to create context filters?

marcus_sommer — Mon, 20 Mar 2017 19:33:14 GMT

Yes, it have - within the tab presentation the first option.

- Marcus

Re: How to create context filters?

Mon, 20 Mar 2017 19:34:40 GMT

Hello Marcus,

It does not work when both the filters are in different alternate state.

Re: How to create context filters?

marcus_sommer — Mon, 20 Mar 2017 20:05:45 GMT

I'm not sure if you could connect a search-box within different states with this excluding option but by a listbox-expression like above mentioned you could add a set analysis to the only() function which synchonized the states whereby I couldn't give you the right syntax for it because I don't use this feature and aren't familar enough to it. But I think if you searched for set analysis and alternate sates you will find various hints and examples.

- Marcus

Re: How to create context filters?

Anil_Babu_Samineni — Tue, 21 Mar 2017 02:53:16 GMT

May be this for your list box expression

Aggr(Country, Country) should work

marcus_sommer‌ -- Can i know why do we require Only() function here

Re: How to create context filters?

Tue, 21 Mar 2017 02:59:19 GMT

Hello Anil,

Thank you for your reply but is there an option where I can get a drop down in a list box and hide the selection name if all are selected?

Re: How to create context filters?

Anil_Babu_Samineni — Tue, 21 Mar 2017 03:02:00 GMT

1) You can create a Multi-box with a single field that will replicate a drop-down listbox. then remove label and Caption if you want

2) Which section name you want to hide if selection for all? Do you mean Title / Caption??

Re: How to create context filters?

Tue, 21 Mar 2017 03:08:45 GMT

Anil,

1)I want it to display All if no filter is applied

2)Also is there any way to remove the green dot that appears alongside the filed name, I would like to remove that whole part of the multibox.

3)Where do i have to insert the expression we discussed above.

Thanks in advance.

Re: How to create context filters?

Anil_Babu_Samineni — Tue, 21 Mar 2017 03:12:26 GMT

1) This will deserve default in Qlikview

2) Didn't get it(Share image)

3) In List Box -> Expression and copy paste with your fieldname

Re: How to create context filters?

Tue, 21 Mar 2017 03:22:07 GMT

Re: How to create context filters?

Tue, 21 Mar 2017 03:22:33 GMT

I want to create a box similar to one on the right

Re: How to create context filters?

Anil_Babu_Samineni — Tue, 21 Mar 2017 03:34:15 GMT

Then, Go to Simple Search Object and then Select fields and use simple Country then work on it as per your need.

Re: How to create context filters?

Tue, 21 Mar 2017 03:38:07 GMT

I am not able to add expression In Search Object, and my two filters are in alternate states, so cant do without writing an expression.

Re: How to create context filters?

Anil_Babu_Samineni — Tue, 21 Mar 2017 03:42:21 GMT

This? If so, Write expression in Search option from Presentation tab

=Concat({1}Aggr(Country1, Country1),',')

Note: Please mark as helpful if it comes to you so then we can thru from there

Re: How to create context filters?

vijetas42 — Tue, 21 Mar 2017 07:18:23 GMT

hi,

for this type of scenario, you can use expression in listbox country like, aggr(only(Country),Country)