Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

3 Replies
Not applicable

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

hi,

post document with sample data...

Niranjan M.

er_mohit
Honored Contributor II

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

Not applicable

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

Hi,

I made sample. Please check attached file

Community Browser