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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan
MVP
MVP
‎2013-04-25 01:42 AM

Slab Wise age calculation

slb.JPG

I want to calculate above 180 slabs total age value those entres having due date  the following expression is used by me

 

=fabs(SUM(AGGR(if(((vDateForAgeing - num(Date(floor([Ledger Due Dt]))) <=180)),

                 SUM([Ledger BalAmt])),[Location Code], [Customer Code])))

Please help to arrive the same.

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Labels (1)
Labels
Set Analysis.rar
620 Views
0 Likes
0 Replies