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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Same day last year - Set Analysis

Hi All,

Doing some work in a call center and trying to work out the same amount of calls last year however the dates are not matching up!

Would any of you be able to help?

Im using the standard master caledner script to create the fields and using set analysis to create two fields

Currrent year - Sum({<CurYTDFlag={1}>} Calls)+SUm({<CurYTDFlag={1}>} Offered)

Last Year - SUm({<LastYTDFlag={1}>} Calls)+SUm({<LastYTDFlag={1}>} Offered)

Have attached picture

Labels (1)
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Then change the way Day is calculated.


talk is cheap, supply exceeds demand