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.
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
What is the error?
Please find the error screen shot below while loading the cross table with main data,
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
Thanks a lot buddy... It works like a charm...
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....
Also the Revenue data is not populating... instead of that month values are populating in the Revenue column...
Glad to know it worked, please close the thread by marking correct & helpful ans
Can u share QVD?
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?
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