Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

daisy1438
New Contributor

date format issue?

Hi

I have date field with time stamp.

mydate:

29/03/2018 22:38:10

29/03/2018 22:42:19

29/03/2018 22:44:10

08/04/2018 09:32:14

08/04/2018 10:38:19

08/04/2018 12:39:07

14/05/2018  08:55:18

14/05/2018  10:56:16 like that.

my requirement is first i need to create the month field.above date it is available 3 months and each month having multiple date because time stamp.so i need to create only one date instead of 3 dates.like below

Month:

MAR-2018

APR-2018

MAY-2018

JUN-2018  like that,how to achieve this.

I am writing the exp in script level for month field like

date(floor(date(mydate,'DD/MM/YYYY hh:mm:ss'),'MMM-YYYY') as month

after derive the month field i want to create the line chart with rolling 12 months.if i have 4 months how to write the expression.

Thanks