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?
Solved! Go to Solution.
Just an example of how you can accomplish this in your Load Script:
Dual('Q' & ceil(Month(DECDDT)/3), ceil(Month(DECDDT)/3)) AS Quarter,
For further information: almost every MasterCalendar example script available in this Community shows you how to calculate the Quarter value from a date field. In different ways.
'Q' & Ceil(Month(DECDDT)/3) as Quarter
Thankyou that helped tremendously, however it has grouped the years in together
q1= Jan 2016 feb 2016 mar 2016
Jan 2017 feb2017 mar 2017
q2= apr 2016 may 2016 jun 2016
apr 2017 may 2017 jun2017
I want the quarters to year specific, how can this be done?
You mean to say, You have only 2016 and 2017 Data. Is that is correct, Although you can use same as perter and my suggestion to the en-count. If not, Please share sample data to look
May be helps