topic Re: grouping fields 'date' in Connectivity & Data Prep

grouping fields 'date'

Fri, 09 Oct 2015 10:00:30 GMT

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

Re: grouping fields 'date'

Fri, 09 Oct 2015 11:20:32 GMT

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

Re: grouping fields 'date'

jonathandienst — Fri, 09 Oct 2015 11:27:13 GMT

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

Re: grouping fields 'date'

Fri, 09 Oct 2015 12:00:00 GMT

OK, thanks!

Re: grouping fields 'date'

Fri, 09 Oct 2015 12:01:14 GMT

OK, thanks!