Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

markus_dreuw
New Contributor

1 Filter to determine 2 Filters independently

HI,

I want to creat an overview dashboard showing import and export flows on each side of the screen.

The data consists, among others, of elements like consignee and consignor + Traffic Direction (Import / Export)

Some consignees have import and export flows and I want to show the overall "client picture" in the dashboard.

This means I need a filter where I can chose the client name, e.g. PANASONIC.

This filter than should set PANASONIC as consignor for my export view and as consignee for my import view, without affecting the other side's figures.

How can I create such a "master-filter" that applies for consingee and consignor linked with the Import/Export selection.

Thanks

Markus

8 Replies
Digvijay_Singh
Honored Contributor III

Re: 1 Filter to determine 2 Filters independently

Not sure but you may create one island table( Master Filter) with all the names. You make 'PANASONIC' selection in this master filter. You can set up other filters or charts by comparing this value using Getfieldselections(Masterfilter).

Or may be via using alternate state.

krishna_2644
Valued Contributor III

Re: 1 Filter to determine 2 Filters independently

Check out this Logic.(dont worry about the buutons,just logic)

Its All about the BUTTONS.

markus_dreuw
New Contributor

Re: 1 Filter to determine 2 Filters independently

This might be an option but this would mean having a huge manual effort, every time a new client would be added to the data base. Then, it would ne necessary to amaend the master table manually.

markus_dreuw
New Contributor

Re: 1 Filter to determine 2 Filters independently

This is not helping for determining 2 dimensions with one filter at the same time.

I want to show Import and Export figures on the same sheet.

erik_wetterberg
Honored Contributor

Re: 1 Filter to determine 2 Filters independently

Hi Markus,

What does your data model look like? You could probably solve this in the data model and that might be both easy and give your users a really powerful solution.

Erik Wetterberg

Erik Wetterberg
https://extendingqlik.upper88.com/
markus_dreuw
New Contributor

Re: 1 Filter to determine 2 Filters independently

Hi Erik,

in the data model I have different columns/dimensions for e.g.

consignee

consignor

traffic direction

turnover

...

Don't know what to change in the data model?!

Regards

Markus

erik_wetterberg
Honored Contributor

Re: 1 Filter to determine 2 Filters independently

Hi,

Not sure this is a good idea without access to your data modell, but you could instead have fields like role (consignee/consignor) and company (PANASONIC).

Erik Wetterberg

Erik Wetterberg
https://extendingqlik.upper88.com/
markus_dreuw
New Contributor

Re: 1 Filter to determine 2 Filters independently

The problem is, that this model cannot be changed as other systems need to have this seperation.

Community Browser