Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Then change the way Day is calculated.


talk is cheap, supply exceeds demand