topic Re: To find Quarter from Date in QlikView

To find Quarter from Date

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

Hi All,

I am using below script to find Quarter from Date.

Ceil(Month([Order Date])/3)

And it is working fine.

However I want to understand if I write only Month (Date), it returns Jan, Feb like this.

Then if I divide this by a number, how come this became a number.

How Jan/3 = 0.3333333?

Please help me to clear my concept.

Thanks,

Sarif

ali_hijazi — Fri, 22 Dec 2017 08:54:36 GMT

'Q' & Ceil(Month(Date)/3) as QUARTER

for dates internally they are numbers but since it is date then Qlik "displays" it as a readable month

if you want to display the number of the month then use num(Month(Date))

Hope I was able to clarify

mhmmd_srf — Fri, 22 Dec 2017 08:58:46 GMT

Hello ali,

My Question is how does it works.

Thanks,

Sarif

ali_hijazi — Fri, 22 Dec 2017 08:59:32 GMT

I edited my reply

check please

mhmmd_srf — Fri, 22 Dec 2017 09:34:49 GMT

Okk.. got it..

so is this only for Date or similar nature we can see for others also.

Thanks,

Sarif

ali_hijazi — Fri, 22 Dec 2017 10:16:31 GMT

as far as I know it's for date data type