Thanks for ur input. I have uploaded file in same manner and listbox quarter and year appearing individually. Like... Q1,Q2,Q3,Q4 and 2012.
Where i want the list box in this manner in 2 different list box...which is not appearing in this format, if i am uploading as it is...
Quarter Year Q1 2011 Q2 2012 Q3 2013 Q4 2014 and so on
The data is in following format. Sorry couldn't provide data point due to compliance of organization. Hope this much will help you to understand the file.
Dummy File.xlsx 14.6 K
Yes you can try with cross table i provide you the load script part for the same check the load script. First load cross table and then load the resident table and then extract the Yearfield and Quarted field from the list. And do not load the Year part that is year column 2012, 2013 and 2014 and create SET expression in the front end for this calculation.
CrossTable(Dates, Data, 4)
(ooxml, embedded labels, table is Sheet2);
LOAD * Resident T1;
DROP Table T1;
if( IsNum(Left(Dates,2)),1,0) as Flag,
Date(Date#(Right(Dates,2),'YY'),'YYYY') as YearField,
Left(Dates,2) as QtrField,
Where Not IsNum(Left(Dates,2));
DROP Table T2;
And in load script use Where Not IsNum(Left(Dates,2)); for not load the year columns.
Thank you so much. It was great help. Got some more issue..will discuss tomrrow. But before that pplease guide me in following concern.
I am completeing new to qlikview application. Had just a day training on desging on Nov and started with project. But my work demands the development and scripting part as well. In current situtation i can't get any training by org. and depending on self learning. So can you help me, is it any other way to learn by using online material or any other refrences. Or else u can able to provide some material on dvelopment and scrpiting.
I followed your given script. Please find the result attached. In result, i am getting 2022 and 2031 in the yearfield but these are not in the original file. Also, there is one more category which u can see in dummy file "LTM" for which i need different field, so plz guide for the extended script. I have attached the updated dummy file for the refrence.
Thanks and Regards,