Nested analysis problem

Fri, 21 May 2010 11:33:21 GMT

Dear community, I have would like to do the following, which I fell should be easy, but I'm unable to . Can you please help ?

Nested analysis problem;

Given the Table:

Name	Date	Value	Location
N1	Jan	10	L1
N1	Feb	11	L1
N2	Jan	5	L1
N3	Feb	4	L2
N4	Feb	5	L2
N4	Jan	10	L2
N5	Jan	10	L3
…	..	..	..

I would like to have a table that shows for each NAME the Total VALUE over a pre-select period (easy) but also in the same line the relative weight of this value for all entities on the same location.

Let's say that the Period is already selected, so the =Sum(Value) gives the correct answer. The problem is how to weight this over all of the same location, since I couldn't find a way to sum over the entire set that as the same Location of the "current line" . In English J :

Total weighted = Sum (Value) / Sum (select all Values where Location = this line Location).

Any ideas ?

Best regards,

ptspy

Re. :Nested analysis problem

martin59 — Fri, 21 May 2010 13:31:00 GMT

hello,

I think you can do that if you use a chart and location is a dimension :

Total weighted=Sum(Value)/Sum(TOTAL <Location> Value)

Martin

topic Nested analysis problem in QlikView

Nested analysis problem

Re. :Nested analysis problem