problem with set analysis

Tue, 30 Nov 2010 12:19:16 GMT

Hi all ,

in my project I have some data organized in this way

Date1 A1 B1
Date2 A2 B2
.
.
Daten An Bn

The values An e Bn (both number), are calculated with those formulas (vStartDate and vEndDate are variables for the search interval) (colonna_data e Chiarezza are column in my QV db)

An = (avg({<colonna_data={">=$(vStartDate) <=$(vEndDate)"}>}(Chiarezza)) * 100/9 )
Bn =(count({<colonna_data={">=$(vStartDate) <=$(vEndDate)"}>}(Chiarezza)) )

I need to calculate this value:

(A1*B1)+(A2*B2)+....+(An*Bn)

If I write the formula

=(avg({<colonna_data={">=$(vStartDate) <=$(vEndDate)"}>}(Chiarezza)) * 100/9 )*(count({<colonna_data={">=$(vStartDate) <=$(vEndDate)"}>}(Chiarezza)) )

the result is
(A1+A2+..+An)*(B1+B2+..+Bn)
that is not what I want

Any help will be appreciated

Thanks in advance

Alessandro

problem with set analysis

marcel_olmo — Tue, 30 Nov 2010 12:34:45 GMT

Could you upload a little document with all these stuff? Otherwise could be hard where is exactly the problem.

Arrivederci!!

topic problem with set analysis in QlikView

problem with set analysis

problem with set analysis