Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make inline table map with months and display quarter

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.

5 Replies
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;

Not applicable
Author

Thank you buddy that was helpful

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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>