Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
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
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 ?
Hi,
I have done the same thing with out using inline check this is usefull or not.
Regards,
Ajay
I'm currently using Personal edition so can't open the document.
Dear Ajay, Can u Pls copy paste the code ?