Qlikview for Developers - A solo exercise

[Anonymous]

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.

[Anonymous]

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...

[kakani87]

Something like this?

[Anonymous]

Yes... exactly... how to achieve this... I have tried many ways... I couldn't get the result.... Can u guide me....

[shiveshsingh · Accepted solution]

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

[shiveshsingh]

use a pivot table, and drag month column to horizontal

[Anonymous]

Thanks a lot shiveshsingh‌.... Now i got the required result.... ....

[shiveshsingh]

Glad to know it worked