Aggregation of Dates

[#1]

Hello Qlik Experts,

I have something like a Late collection data at the day level. I want to use that in a chart with a Dimension and was wondering how could I group them at the Month level?? Please look at the screen shot attached here to see what I mean and any help is greatly appreciated.

The expression is something like seen here , with a Date Dimension

=sum(Termination_Date_Total_Value)/
(sum(Late_Collection_Init_Date_Total_Value)+
sum(Claim_Accrued_Between_Late_Coll_Init_And_Termination_Date_Value))

[#2]

Any takers for this please??

[kaushiknsolanki]

Hi,

   To get month out of the date, all you have to do is use month() function in your load statement. For example.

   Load Date,

   month(date) as Month

   From ...........

   Use the month as dimension in your chart.

    Hope this will help you

Regards,

Kaushik Solanki