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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
aaronnayan
Creator III
Creator III

Date field to Quarters

Hi Guys

How would I include in my Qlikview doc the option to select date in Quarters

My date field is DECDDT

i.e. Q1, Q2, Q3, Q4

How would i do this in my script?

10 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Simpeler, this one?

:

Dual('Q' & ceil(Month(DECDDT)/3) & ' ' & Year(DECDDT),

    QuarterStart(DECDDT)) AS Quarter,

: