My requirement is not to sort the data while viewing the contents of column in table box format. When I execute the script, I have a xml from which i import data. The data it fetches is correct but in a sorted format. The order is in ascending format but I want QlikView to display the data in the same order as it fetched from the xml i.e. in the original format without any sorting. Can you please help me to achieve this? Thanks!!
But I have another query. Problem is suppose in the xml file I have a tag in a format like:
<funding>There is a pool</funding>
<funding>Deliver your best</funding>
<funding>World Wide Web</funding>
and so on...
When I Load this data from the xml, for each <item> I have to load each of the funding information in separate columns which I have succeded to do so. Now when I am viewing the data in table box format, for each <item> the data for funding gets arranged in ascending order. eg
1) For xyz_1234 data fetched is: Megacity InnThere is a poolScoch Corporation
where correct format should be like
Scoch CorporationThere is a poolMegacity Inn
2) For pqr_1234 data fetched is: Deliver your best MacintoshWorld Wide Web
I donot understand you well... I mean, I donot know if you have 4 fields: item, funding1, funding2 and funding 3; or only 2: item and funding. And if you need to order them first by item and later by funding...
Can you explain it? It would heko if you attach you xml file.