
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
'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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
'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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello ali,
My Question is how does it works.
Thanks,
Sarif


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I edited my reply
check please

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Okk.. got it..
so is this only for Date or similar nature we can see for others also.
Thanks,
Sarif


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
as far as I know it's for date data type
