Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bala_krish
Contributor
Contributor

Qlikview for Developers - A solo exercise

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.

Crosstable.JPG

1 Solution

Accepted Solutions
shiveshsingh
Master
Master

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

View solution in original post

16 Replies
shiveshsingh
Master
Master

What is the error?

bala_krish
Contributor
Contributor
Author

Please find the error screen shot below while loading the cross table with main data,

Error_Crosstable.JPG

shiveshsingh
Master
Master

Do one thing, create your crosstable first and then concatenate it using resident load.

actually your crosstable is not created , that's why you are getting error

bala_krish
Contributor
Contributor
Author

Thanks a lot buddy... It works like a charm...

bala_krish
Contributor
Contributor
Author

Eventhough it's working.. I'm not able to get the desired results after the loading. Month and it's corresponding numbers are not matching. Please find the related screen shot....

Crosstable_Facttable.JPG

Also the Revenue data is not populating...  instead of that month values are populating in the Revenue column...

shiveshsingh
Master
Master

Glad to know it worked, please close the thread by marking correct  & helpful ans

shiveshsingh
Master
Master

Can u share QVD?

bala_krish
Contributor
Contributor
Author

Hi Shivesh,

I'm unable to attach anything in the comment section... It attachment facility available in the discussion only.... Can u please tell me any other feasible way?

kakani87
Specialist
Specialist

open your thread in browser view then you will be able to see on right top corner use advanced editor

select it to attach any files.

Have a look at the screen

Attach_file.png