Skip to main content

Qlik

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
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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: 
Not applicable
‎2013-04-04 05:38 PM

Is there a way to do a prorated calculation without adding to script?

Hello,


I'm working on a similar issue with this link: http://community.qlik.com/message/330465#330465

But - I'm wondering if there's a way to do a Prorated calculation based on a Start Date. The date model has an Activity table - the Employee joined by Employee ID and the calendar joined to the Activity table by date.  Here's what I have thus far and it results in a static number, which is correct - but if someone starts in a year (say 2012), I need to prorate the days available based on when a sales rep started:

aggr(sum(TOTAL([Available Days])),[Date],[Sales Rep],[Date Year],[Employee Start Date],[Employee ID])

Thanks in advance

Neal

374 Views
0 Likes
1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2013-04-05 02:19 AM

Hi,

     Could you please attache the sample QVW file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
253 Views
0 Likes