Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-10-10 05:58 AM

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.

Thanks

Khushboo

235 Views
0 Likes
1 Reply
adamdavi3s
Master
Master
‎2016-10-10 06:43 AM

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

148 Views