topic How to display year Quarter Month using Qlik view ? in QlikView

How to display year Quarter Month using Qlik view ?

Mon, 06 Dec 2010 07:52:40 GMT

Please find attached file . Please suggest how to display Year,Quarter and Month horizontally using 3 listboxes from the attached data.

Also suggest any suitable display of the attached.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/674/2021.data.xls:550:0]

How to display year Quarter Month using Qlik view ?

Mon, 06 Dec 2010 11:55:51 GMT

Hi,

I think this will able to solve u r problem

Date:
CrossTable(MonthYear, Data, 3)
LOAD * FROM

(biff, embedded labels, table is Sheet1$);

Final_Date:
Load
Region,
Geography,
Category,
Right(Trim(MonthYear),4) as Year,
Left(Trim(MonthYear),3) as Month
Resident Date ;
Drop table Date;

LOAD * INLINE [
Month, Quarter
JAN,Q1
FEB,Q1
MAR,Q1
APR,Q2
MAY,Q2
JUN,Q2
JUL,Q3
AUG,Q3
SEP,Q3
OCT,Q4
NOV,Q4
DEC,Q4

];

Regards,

Ravi

How to display year Quarter Month using Qlik view ?

Mon, 06 Dec 2010 12:43:08 GMT

Yes it worked, actually unchecking the "single column" field does the trick bringing the values of listbox horizontally. Now Year, Quarter and month are in horizontal direction.

Thanks a lot for the support.

Can UI suggest any chart which will be suitable to display the overall data ?

How to display year Quarter Month using Qlik view ?

spsrk_84 — Mon, 06 Dec 2010 12:45:40 GMT

Hi,

I have done the same thing with out using inline check this is usefull or not.

Regards,

Ajay

How to display year Quarter Month using Qlik view ?

Tue, 07 Dec 2010 08:01:30 GMT

I'm currently using Personal edition so can't open the document.

Dear Ajay, Can u Pls copy paste the code ?