topic Re: Set Analysis - sum & min in QlikView

Set Analysis - sum & min

Tue, 16 Aug 2011 12:03:59 GMT

Hi,

I have the following crosstable :

I need to add a column (look at the table below) where :

for each [GA_Date_GAA2]

needed column = sum(Active_GAA2) / sum({<month_GAA2=min(month_GAA2)>} Active_GAA2)

Regards,

Yacine

lironbaram — Tue, 16 Aug 2011 12:24:10 GMT

hei

attch is an example

hope youll find it helpful

Wed, 17 Aug 2011 08:13:49 GMT

thank you liron, it was helpfull but there is a small issue with that expression that I can't fix:

=sum(Value)/sum({<Month={"$(=min(Month))"}>} total <Date> Value)

the expression works only when month = 1; the "min(month)" should be calculated for each "date".