Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YTD,QTD weeknumber Calculations

Hi All,

I have Yearweek available in my calendar. I want to compare this Year YTD Vs Pervious year YTD.

Same for QTD as well.

i want to calculate values for all weeks here.

Can anyone help me to how to extract YTD for all weeks.



1 Reply

What are you using as your stopping point, i.e. if you want to see YTD in weeks, do you do all weeks until the last Sunday for example?

If you reload daily then calculating a YTD & PYTD flag in the calendar script is really the best way to go (IMHO) as you can simply use this in set analysis then