This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
Dual('Q' & ceil(Month(DECDDT)/3) & ' ' & Year(DECDDT), Year(DECDDT)*10+ ceil(Month(DECDDT)/3)) AS Quarter,
View solution in original post
What is "DECDDT" ? Could you explain your date field data format?
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
yes Anil so i would like Q1 2016 then Q2 2016 and so on and so on
what about QuarterName() function ?
QuarterName('01-01-2017') -> gen-mar 2017
May be helps
quartername ‒ QlikView