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

How to make inline table map with months and display quarter

Wed, 15 Oct 2014 19:24:29 GMT

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.

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

its_anandrjs — Wed, 15 Oct 2014 19:34:08 GMT

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;

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

Wed, 15 Oct 2014 19:38:04 GMT

Thank you buddy that was helpful

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

Wed, 15 Oct 2014 19:44:09 GMT

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

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

Wed, 15 Oct 2014 20:34:54 GMT

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

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

Thu, 16 Oct 2014 04:19:48 GMT

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>