topic Re: 1 Filter to determine 2 Filters independently in App Development

1 Filter to determine 2 Filters independently

markus_dreuw — Fri, 16 Mar 2018 08:12:04 GMT

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

Re: 1 Filter to determine 2 Filters independently

Digvijay_Singh — Fri, 16 Mar 2018 17:59:13 GMT

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.

Re: 1 Filter to determine 2 Filters independently

Qrishna — Sat, 17 Mar 2018 04:10:37 GMT

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

Its All about the BUTTONS.

Re: 1 Filter to determine 2 Filters independently

markus_dreuw — Tue, 20 Mar 2018 08:24:22 GMT

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.

Re: 1 Filter to determine 2 Filters independently

markus_dreuw — Tue, 20 Mar 2018 08:32:36 GMT

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.

Re: 1 Filter to determine 2 Filters independently

ErikWetterberg — Tue, 20 Mar 2018 09:41:50 GMT

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

Re: 1 Filter to determine 2 Filters independently

markus_dreuw — Tue, 20 Mar 2018 10:14:48 GMT

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

Re: 1 Filter to determine 2 Filters independently

ErikWetterberg — Tue, 20 Mar 2018 10:27:33 GMT

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

Re: 1 Filter to determine 2 Filters independently

markus_dreuw — Tue, 20 Mar 2018 10:34:09 GMT

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