Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

month avg

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

13 Replies
brijesh1991
Partner - Specialist
Partner - Specialist

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;

brijesh1991
Partner - Specialist
Partner - Specialist

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;

brijesh1991
Partner - Specialist
Partner - Specialist

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;

Not applicable
Author

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.