Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

financial qtr script error

hi,

i have the follwoing script in my calender

Upper(Month(monthstart($(TimeField)-26,1))) as Month,

how can i get my quarters code to follow this logic?

Dual('Q'&Num(Ceil(Num(Month($(TimeField)))/3)),Num(Ceil(NUM(Month($(Timefield)))/3),00)) as [Quarter],

I HAVE TTRIED THE FOLLOWING

Dual('Q'&Num(Ceil(Num(Month($(TimeField)-26,1))/3)),Num(Ceil(NUM(Month($(Timefield)-26,1))/3),00)) as [Quarter],

best

BRAD

0 Replies