3 Replies Latest reply: Jan 22, 2013 6:27 AM by Uguudei E

# Aggr function and set analysis help  !!!!!

Hi everyone,

I'm learning qlikview and in need of help. Please someone explain me how this aggregation functions work. Also help me in set analysis

Chart 1: Dimension is [date day of month]

I have these expressions working correctly:

1. Below shows current month sum of sales

Sum({\$<[_date M] = {\$(=Max([_date M]))}, \$(eMonth) = {\$(=Only(\$(eMonth)))} >} Sales)

2. Below shows current month avg

avg(TOTAL aggr(sum(Sales),[date Day of month]))

3. Below shows previous month sum of sales

Sum({1<[_date M] = {\$(=Max([_date M]-1))} >} Sales)

[date day of month] -days of month

[_date M] -month series

eMonth -month of year

year and month will be selected in selection.

I NEED THOSE:

1. How can i show daily avg sales of selected year excluding selected month values?

2. How can i show daily avg sales of previous month (of selected month)?

Chart 2: Dimension is [date day of month]

3. How can i show below expressions?

evere day is divided by first day of

like : day1/day1 , day2/day1, day3/day1

So that can see how much sales increased or decreased since first day of month

Sorry for my english grammer errors

• ###### Re: Aggr function and set analysis help  !!!!!

hi,

post document with sample data...

Niranjan M.

• ###### Re: Aggr function and set analysis help  !!!!!

Hi,

• ###### Re: Aggr function and set analysis help  !!!!!

hiiii for avg sale of selected year try

avg({<year={"\$(=year)"}>}sales)

and for previous month:

avg({<year={"\$(=(emonth)-1)"}>}sales)

for chart comparision see attached file