Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Big Bet Webinar, March 10th: Learn 7 ways to accelerate business insights REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Bart_Breekveldt
Contributor III
Contributor III

Period count when year starts

Dear community,

I've made a new date function, a period of four weeks (we don't use months, but periods which results in 13 instead of 12 date periods per year). The script which I've used to make the field in the pivot table is ("Datum-Tijd" = Date-Time in English)

=Dual('P'&Num(Week([Datum-Tijd]/4),00),Num(Week([Datum-Tijd]/4),00))

(The installed sensors, which count the passing trays, are brand new and in the test phase, so not four weeks are shown per period)

Here is my question: how can I set the period count to start when the year starts? So for example week 1-4 are period 1 and week 5-8 period 2. The function gives me periods in de 40s, which is unhelpful. 

Do you know how to start the period count when the year starts?

Thanks in advance.

Pivot table date functions.PNG

0 Replies