To find Quarter from Date

[mhmmd_srf]

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 · Accepted solution]

'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]

Hello ali,

My Question is how does it works.

Thanks,

Sarif

[ali_hijazi]

I edited my reply

check please

[mhmmd_srf]

Okk.. got it..

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

Thanks,

Sarif

[ali_hijazi]

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