How to Consider Maximum Date in Each Month as Dimension ?

[tulasiram_bitra]

Hi Frnz,

I would like to show monthly wise  count({$<Aging_Category={'0-30'}>}Aging_Category).

but here i have to consider maximum date in each month. i.e.,

Jan - 31st [ Depends on my data ]

Feb - 28th

------

Please help me to write expression for that.

Here Dimension  ==> Month

        Expression  ==> count({$<Aging_Category={'0-30'}>}Aging_Category)

[tulasiram_bitra]

Hi,

I have attached qvw. Please find this.

I have used this formulae : count({$<Aging_Category={'0-30'},Date={'$(=max(Date))'}>}Aging_Category).

This is working, but here it is showing only one month in dimension.

Can you please suggest, how to show all months in dimension.

[sunny_talwar · Accepted solution]

Do you want this?

Expressions:

FirstSortedValue(Aggr(Count({$<Aging_Category={'0-30'}>}Aging_Category), Month, Date), -Aggr(Date, Month, Date))

FirstSortedValue(Aggr(Count({$<Aging_Category={'31-60'}>}Aging_Category), Month, Date), -Aggr(Date, Month, Date))

FirstSortedValue(Aggr(Count({$<Aging_Category={'61-90'}>}Aging_Category), Month, Date), -Aggr(Date, Month, Date))

[jagan]

Hi,

In that case try like this

Data:

LOAD

*,

MonthName(DateFieldName) AS MonthName,

FROM DataSource;

LEFT JOIN(Data)

LOAD

MonthName,

Max(DateFieldName) AS DateFieldName,

1 AS MaxDateInMonthFlag

Resident Data

Group By MonthName;

Now in your expression just use

Dimension = Month

Expression= count({$<Aging_Category={'0-30'}, MaxDateInMonthFlag={1}>}Aging_Category)

Hope this helps you.

Regards,

jagan.