Aggr function and set analysis help !!!!!

Tue, 22 Jan 2013 10:13:44 GMT

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 !!!!!

Tue, 22 Jan 2013 10:32:31 GMT

hi,

post document with sample data...

Niranjan M.

er_mohit — Tue, 22 Jan 2013 11:25:27 GMT

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

Tue, 22 Jan 2013 11:27:05 GMT

Hi,

I made sample. Please check attached file