Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

> 12 month value aggregation in one column

I have month year column.

I need to aggregate value for all month year having value > 12 month, I am using dimension as per below please suggest.

=If(Date(AR_CustomerLedger.MonthYear, 'MMM-YYYY') >= Date(AddMonths(Today(),-11), 'MMM-YYYY'), Date(AR_CustomerLedger.MonthYear, 'MMM-YYYY'), '> 1 Year')

12 Replies
sunny_talwar

What is the issue you are running into?

deepakqlikview_123
Specialist
Specialist
Author

I am not able to get aggregated value eual to value in that perticular selection.

below is discussion for this.

Pivot table condition

sunny_talwar

Would you be able to attach a sample here?

deepakqlikview_123
Specialist
Specialist
Author

PFA

deepakqlikview_123
Specialist
Specialist
Author

Hi all,

Can you please suggest on this how shall i go ahead to get result as shown in attachment.

PS-I am using pivot table

Thanks

sunny_talwar

Try this expression
SUM({<AR_CustomerLedger.MonthYear>}AR_CustomerLedger.OpenAmount)

deepakqlikview_123
Specialist
Specialist
Author

hi sunny,

thanks for response it is  working fine for last 3 months data.moreover can you please suggest how to sort the column in descending order of month year.

thanks

sunny_talwar

it is  working fine for last 3 months data

Not working for other data?

sunny_talwar

Check attached