Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
patricesalem
Creator II
Creator II

In Semester to date

Hello 

 

Is there a way to add a script in the auto calendar that will help me in expression for selecting in semester to date sales ?

 

entries in the standard autocalendar are 

If (DayNumberOfYear($1) <= DayNumberOfYear(Today()), 1, 0) AS [InYTD] ,
If (DayNumberOfQuarter($1) <= DayNumberOfQuarter(Today()),1,0) AS [InQTD] ,
If(Day($1)<=Day(Today()),1,0) AS [InMTD] ,

....

Num(Week($1)) AS [#Week],
Num(Month($1)) AS [#Month],
Ceil(Num(Month($1))/3) AS [#Quarter],
Ceil(Num(Month($1))/6) AS [#Semester],
Num(Year($1)) AS [#Year],
;

DERIVE FIELDS FROM FIELDS [D_SALES],
[D_TARGET]

 

 

Thanks for your help

Labels (1)
0 Replies