topic Re: Date format ? in QlikView

Date format ?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

My input Data like below

Month	Product
5/1/2017	A
4/25/2017	B
4/10/2017	X
4/7/2017	B
3/23/2017	B
3/22/2017	R
3/22/2017	B
3/8/2017	C
2/28/2017	C
2/14/2017	X
2/8/2017	C
2/8/2017	S
2/6/2017	C
1/27/2017	C
1/25/2017	D
1/18/2017	D
1/17/2017	D
1/17/2017	I
1/17/2017	D
1/17/2017	D
1/12/2017	J
1/12/2017	E
1/11/2017	M
1/10/2017	E

expected out put should like below , trying with monthsrat ? but some records are missing

Month	Product
May-2017	A
APR-2017	B
	X
	B
MAR-2017	B
	R
	B
	C
FEB-2017	C
	X
	C
	S
	C
Jan -2017	C
	D
	D
	D
	I
	D
	D
	J
	E
	M
	E

Thanks,

Re: Date format ?

sunny_talwar — Mon, 08 May 2017 11:13:08 GMT

You don't want the date to repeat? On the front end? In like a pivot table or are you looking to do something like this in the script? Can you share more details around what records are missing?

Re: Date format ?

prma7799 — Mon, 08 May 2017 11:21:45 GMT

Like this?

PFA....

Re: Date format ?

MindaugasBacius — Mon, 08 May 2017 11:36:42 GMT

Maybe:

Date(Date#('5/1/2017', 'MM/DD/YYYY'), 'MMM-YYYY')