simple data modelling question

Fri, 28 Jan 2011 16:05:03 GMT

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

simple data modelling question

Fri, 28 Jan 2011 16:19:41 GMT

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.

simple data modelling question

Fri, 28 Jan 2011 16:25:23 GMT

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...

topic simple data modelling question in QlikView

simple data modelling question

simple data modelling question

simple data modelling question