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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

create a derived field

how to create a derived field and provide values into it through script

1 Reply
Not applicable
Author

Hello 3 Idiots,

perhaps this can serve you as an example:


IF(MONTH(MyDate) <4, 'Q1',
IF(MONTH(Mydate) <7, 'Q2',
IF(MONTH(MyDate) <10,'Q3',
IF(MONTH(MyDate) <13,'Q4',
'Q5')))) AS MyQuarter,


Regards, Roland