Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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.

Tags (1)
5 Replies
its_anandrjs
Not applicable

Re: How to make inline table map with months and display quarter

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

Re: How to make inline table map with months and display quarter

Thank you buddy that was helpful

Not applicable

Re: How to make inline table map with months and display quarter

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

Not applicable

Re: How to make inline table map with months and display quarter

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

Not applicable

Re: How to make inline table map with months and display quarter

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>