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

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
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

Labels (1)
0 Replies