simple data modelling question

[#1]

I have a question about data modelling and the qlikview internal logic.

I have quite a simple datamodel:

I have some 'measures' in the Customer table that I want to put in a chart. 'Dimensions' are in the Customer and Organisation tables.
I want to view these data independently of the other tables, and selections that exist therein.

I have already a few sheets with charts on the other tables+Organisation

Now I want a sheet with charts that are not affected by the filters/selections in these other sheets.
E.g. if I filter on Time in the first sheet --> limits results in EOSUsage --> limits possible Organisation members --> does not show full results in my new sheet/chart.

I know I can 'fix' this using set analysis, but this would mean I would have to include every possible filter/select field in my set analysis expression, which would become extremely long and very bad when it comes to maintainance.

I tried the expression
=Count({$<_Organisation_WID=>} CustomerNumber)
with _Organisation_WID being the field that links the Organisation and EOSUsage tables
but this doesn't work - it still filters on e.g. the Time fields

It would be nice to be able to specify this in the set analysis expressions;
something like $<link_between_Organisation_and_EOSUsage=ignore>

Or even better: specify this at the chart- or sheet-level.

How do you handle this kind of situation? I think this is a very common problem.
I CAN solve this (using sheet OnActivate trigger to clear most selections, or using a very big set analysis expression), but I suppose there are better solutions.

thanks,

Nico

[#2]

Hi ,

Hope this helps you ....

Simple solution for your problem is just add {1} to the expression

Ex .. Sum({1} Sales ).. So that it will reflect for any of your selections ...

Regards,

Chakravarthy.

[#3]

hmm

that would be the same as detaching the chart, no?

I cannot do this, since I want to have filters on certain fields from the Customer and Organisation tables...