Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Common Date and Calendar Help

Hi All,

I've been beating my head against my desk trying to get this to work.  I need to be able to compare a Sale Reps Sales vs their Quotas for months, quarters, and years  The Quotas are kept in an excel doc, their sales are kept via salesforce. I've tried many different things, and none seem to work.  I've read several well written blogs / posts by Rob Wunderlich and Henric Constrom on this very subject.

I've attached the most simplified version of a .QVW that I can get.

Can anyone help me out here?  What am I missing / doing wrong?  (To be fair - I have little clue to what is happening in the calendar subroutine. Building a calendar in that manner is new for me.  That was a copy from Rob Wunderlich's examples)

Thanks!

Dan Mercer

Added QVW with date(floor( Message was edited by: Dan Mercer

Message was edited by: Dan Mercer Added Document with Apply Map.  Still not functioning.

10 Replies
Anonymous
Not applicable
Author

Ok - I went back to the original model, and created a synthetic key between the dates and user ID's and the application works as I'd expect.  Why is that?