Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
Thank you buddy that was helpful
You have a Quarter(Date) function that shows you the quarter of the Date give as parameter
but v only have quarterstart,quarterend and quartername as functions available
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>