grouping fields 'date'

[#1]

hi! how it work to grouping fields 'date' to months, quarters, years? Or if it possible to use sql functions month(), year()?

[#2]

In Qlik:

Month([YourDate])             AS Month,

Ceil(Month([YourDate])/3)  AS Quarter,

Year([YourDate])               AS Year

in SQL:

Month([YourDate])                        AS Month,

CEILING(Month([YourDate])/3)     AS Quarter,

Year([YourDate])                          AS Year

[jonathandienst]

Any Qlikview calendar load scripts will work equally well in QS. There is plenty of material on this site for calendars. Search for Master Calendar and also read these:

How to use - Master-Calendar and Date-Values

Canonical Date

Although these were written for QV, they apply equally to QS with little or no modification

[#4]

OK, thanks!

[#5]

OK, thanks!