Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP & Luminary
MVP & Luminary

Re: Same day last year - Set Analysis

Then change the way Day is calculated.

talk is cheap, supply exceeds demand