Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

To find Quarter from Date

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 

1 Solution

Accepted Solutions
ali_hijazi
Partner - Master
Partner - Master

'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

I can walk on water when it freezes

View solution in original post

5 Replies
ali_hijazi
Partner - Master
Partner - Master

'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

I can walk on water when it freezes
mhmmd_srf
Creator II
Creator II
Author

Hello ali,

My Question is how does it works.

Thanks,

Sarif

ali_hijazi
Partner - Master
Partner - Master

I edited my reply

check please

I can walk on water when it freezes
mhmmd_srf
Creator II
Creator II
Author

Okk.. got it..

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

Thanks,

Sarif

ali_hijazi
Partner - Master
Partner - Master

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

I can walk on water when it freezes