Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi! how it work to grouping fields 'date' to months, quarters, years? Or if it possible to use sql functions month(), year()?
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
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
Although these were written for QV, they apply equally to QS with little or no modification
OK, thanks!
OK, thanks!