Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I'm learning qlikview using Qlikview for Developers Book. In that Crosstable Solo exercise, I want to load a crosstable in to Airline Operations. I have generated the crosstable script separately and it is working fine. But When I used in the Airline operations QVW, I'm not able to use that data in to the Airline Operations QVD.
Hi Shivesh,
Please find the Employment Statistics Crosstable qvd.. And could you please tell me how to use it in the existing Airline Operations data model...
Something like this?
Yes... exactly... how to achieve this... I have tried many ways... I couldn't get the result.... Can u guide me....
T:
LOAD %Key, Year,
[Airline ID],
[Unique Carrier Code],
[Unique Carrier],
[Carrier Code],
[Carrier Name],
[Carrier Group ID (Old)],
[Carrier Group ID],
[01], [02], [03],
[04], [05], [06],
[07], [08], [09],
[10], [11], [12]
FROM
[..\Desktop\Employment Statistics - CrossTable.qvd]
(qvd);
CrossTable(Month,Sales)
load [Airline ID],
[01], [02], [03],
[04], [05], [06],
[07], [08], [09],
[10], [11], [12]
Resident T;
drop table T
use a pivot table, and drag month column to horizontal
Thanks a lot shiveshsingh.... Now i got the required result.... ....
Glad to know it worked