Skip to main content

Qlik

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: 
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: 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

422 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

335 Views