topic Re: quastion about aggr calculation? in QlikView

quastion about aggr calculation?

Mon, 02 Apr 2012 10:57:32 GMT

hi,

i have a quastion about calculation i need to do, i want to calculate for for example:

i have some aggr number for exmple: 40000.

now i want to do calculation for some month, for exp: if its FEBRURY(28 days) and today is the second day of this month(2).

(40000/28)*2.

if its the third(3) day it will be:

(40000/28)*3

i dont know how to do the the exact days of the month(28 days), and each day count.

i think i can do it with COUNT(DD) but i dont sure.

thank you

eran

Re: quastion about aggr calculation?

jagan — Mon, 02 Apr 2012 11:03:06 GMT

Hi,

Try this expression

=((Your Aggr expression)/Day(MonthEnd(Today()))) * Day(Today())

Hope this helps you.

Regards,

Jagan.

quastion about aggr calculation?

CELAMBARASAN — Mon, 02 Apr 2012 11:03:28 GMT

Hi,

you can get the days by Day(MonthEnd(Date))

Celambarasan

quastion about aggr calculation?

Jason_Michaelides — Mon, 02 Apr 2012 11:08:10 GMT

If you have a value for every day in every month you could use Max(Day). Or you could simply create an Inline table in your script of each month and the number of days then either join it to the dates table or use ApplyMap() to put the DaysInMonth field wherever you want it.

Hope this helps

Jason

Re: quastion about aggr calculation?

v_iyyappan — Mon, 02 Apr 2012 11:10:27 GMT

Hi,

Use the expression like this

= ((Aggr expressoin * Day(MonthEnd(Today()))) / Day(Today())

Regards,

Iyyappan

quastion about aggr calculation?

Jason_Michaelides — Mon, 02 Apr 2012 11:10:43 GMT

Using Day(MonthEnd(Date)) is a better solution to mine

quastion about aggr calculation?

Mon, 02 Apr 2012 11:30:56 GMT

hi all,

thank you all for the answers i tried everyone of you and this one Day(MonthEnd(Today()))) was almost this but he always give me 31 and not depends on the month i choose.

maybe i dont write it good but Day(MonthEnd(Date)) gives me an error.

Re: quastion about aggr calculation?

Jason_Michaelides — Mon, 02 Apr 2012 11:34:34 GMT

Try Day(MonthEnd(MakeDate(Year,Month,1)))

This assumes you have Year and Month as fields in your data model.

Edit: Actually, you don't need the '1' in there - Day(MonthEnd(MakeDate(Year,Month)))

quastion about aggr calculation?

jagan — Mon, 02 Apr 2012 11:36:15 GMT

Hi,

Try this

=Day(MonthEnd(Max(YourDateFieldName)))

Regards,

Jagan.

quastion about aggr calculation?

CELAMBARASAN — Mon, 02 Apr 2012 11:37:09 GMT

Hi,

Here Date is the date field you have

Day(MonthEnd(Max(DateField)))

Check it

celambarasan

quastion about aggr calculation?

Mon, 02 Apr 2012 11:57:49 GMT

hi,

i did like this Day(MonthEnd(Max(YYMM))) and he returns(30) the quastion is if next month will be 31 days he will know it?

quastion about aggr calculation?

CELAMBARASAN — Mon, 02 Apr 2012 12:02:31 GMT

Hi,

Try by selecting dates of all other months in the list box.

Is YYMM is date field or what info it has?

Celambarasan

quastion about aggr calculation?

jagan — Mon, 02 Apr 2012 12:05:51 GMT

Hi,

Max(YourDateFieldName) returns the maximum date of the selected filters, here it is dynamic, so if the month has 31 it returns 31, on the same 30 as 30. It is dynamic, based on the selections it vary.

Regards,

Jagan.

quastion about aggr calculation?

Mon, 02 Apr 2012 12:10:08 GMT

i tried to select but it doesnt change.

my YYMM returnes 1204 and it changes when i choose year or different month.

10/2011 it returns 1110

quastion about aggr calculation?

CELAMBARASAN — Mon, 02 Apr 2012 12:15:18 GMT

Hi,

Check do you have any other date field?How you generated day field?

Celambarsan

quastion about aggr calculation?

Mon, 02 Apr 2012 12:45:31 GMT

this is it.

day(monthend(makedate(YYYY,MM,1)))

thank you all