topic Re: Aggr Over Certain Fields in QlikView

Aggr Over Certain Fields

Anonymous — Mon, 06 Apr 2015 00:36:09 GMT

Trying to Create a column (SalesOfFirstMonth) in a chart to pick Sales value of Month = 1 and show against all the clients for that Year. Need to do this on chart level and not in the script. Tried via creating a variable but it shows 105 in all rows.

Client	Month	Year	Sales	SalesOfFirstMonth
a	1	2015	105	105
b	2	2015	95	105
c	3	2015	80	105
d	4	2015	95	105
e	5	2015	100	105
f	6	2015	90	105
a	1	2014	85	85
b	2	2014	95	85
c	3	2014	79	85
d	4	2014	110	85
e	5	2014	90	85
f	6	2014	80	85

Thank you.

Re: Aggr Over Certain Fields

sunny_talwar — Mon, 06 Apr 2015 00:49:24 GMT

This expression should do it:

=Sum({<Month = {1}>} TOTAL <Year> Sales)

Best,

Sunny

Re: Aggr Over Certain Fields

ziadm — Mon, 06 Apr 2015 04:27:38 GMT

use Min Function to select the 1st Month

Min(Month(Date))

Re: Aggr Over Certain Fields

anbu1984 — Mon, 06 Apr 2015 05:16:25 GMT

What is the desired output?

Re: Aggr Over Certain Fields

jagan — Mon, 06 Apr 2015 05:30:00 GMT

Hi,

Try this expression, if you always have 1 as the starting month

=Sum({<Month = {1}>} TOTAL <Year> Sales)

Regards,

Jagan.