topic Re: month avg in QlikView

month avg

Wed, 02 Jan 2013 05:43:50 GMT

Dear Members,

I have follwoing issue

mon amount

jan 5000

feb 30000

mar 40000

so i Want Avg for every month

ex: jan 31 days so avg is 30000/31 days 999 valuu will come

how its change dynamically by every month selection

Re: month avg

sreenivas — Wed, 02 Jan 2013 06:24:38 GMT

PFA of the Solution it may help you out.

Re: month avg

Wed, 02 Jan 2013 06:38:43 GMT

hope this help you

date	amount
1/1/2012	5000

in your expression write

amount / Day(Month(date))

then output display like

date	amount / Day(Month(date))
1/1/12	161.29032258065

thanks.

Re: month avg

brijesh1991 — Wed, 02 Jan 2013 06:41:02 GMT

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

Re: month avg

brijesh1991 — Wed, 02 Jan 2013 06:41:12 GMT

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

Re: month avg

brijesh1991 — Wed, 02 Jan 2013 06:41:24 GMT

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

Re: month avg

brijesh1991 — Wed, 02 Jan 2013 06:41:45 GMT

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

Re: month avg

brijesh1991 — Wed, 02 Jan 2013 06:42:14 GMT

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

Re: month avg

brijesh1991 — Wed, 02 Jan 2013 06:42:38 GMT

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

Re: month avg

brijesh1991 — Wed, 02 Jan 2013 06:42:54 GMT

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

Re: month avg

brijesh1991 — Wed, 02 Jan 2013 06:43:18 GMT

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

Re: month avg

brijesh1991 — Wed, 02 Jan 2013 06:43:46 GMT

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

Re: month avg

brijesh1991 — Wed, 02 Jan 2013 06:44:20 GMT

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

Re: month avg

Wed, 02 Jan 2013 06:46:32 GMT

Hi,

Please see the attached file,

it helps U.

Below expression fullfill ur requirement

Amount1/Day(MonthEnd(MakeDate(2013,WildMatch(Month1,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')))) as MonthAvg

Regards

Kabilan K.