Discussion Board for collaboration regarding Qlik DataMarket.
how to create a bucket only for a date field?
Go to Solution.
Month(date) as mon,
Day(date) as day,
Year(date) as year
(ooxml, embedded labels, table is Sheet1);
if(Match(day,1,2,3,4,5,6,7) , 'bucket1',
if(Match(day,29,30,31), 'bucket5'))))) as bucket
DROP Table table;
You got answer yourself