How to make inline table map with months and display quarter

[#1]

Hi friends i m new to qlikview development.

in my database i only have 'Quote_Generation_Date' as field which consist of dates eg:'4/1/2013' not Months field

so i can display months with months(Quote_Generation_date) as Expression.

how am i supposed to display Quarter with inline table.

Any reply would be highly appreciated.

[its_anandrjs]

If you are able to get the month bu the expression months(Quote_Generation_date) as Expression.

Then try with

Load

Month(Quote_Generation_date) as Month,

'Q'&Ceil( Month(Quote_Generation_date)/3) as Quarter //For Quarter is also works

From Location;

[#3]

Thank you buddy that was helpful

[#4]

You have a Quarter(Date) function that shows you the quarter of the Date give as parameter

[#5]

but v only have quarterstart,quarterend and quartername as functions available

[#6]

Quartername if I'm not wrong gives you something like "Qx" if the parameter

date is within the x quarter.

El oct 15, 2014 5:35 PM, "Tausif Khan" <qcwebmaster@qlikview.com> escribió:

Qlik Community <http://community.qlik.com/> How to make inline

table map with months and display quarter

reply from Tausif Khan

<http://community.qlik.com/people/tausif.khan?et=watches.email.thread> in

Scripting - View the full discussion

<http://community.qlik.com/message/634979?et=watches.email.thread#634979>