topic Qlikview for Developers - A solo exercise in QlikView

Qlikview for Developers - A solo exercise

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Qlikview for Developers - A solo exercise

shiveshsingh — Wed, 04 Apr 2018 17:25:00 GMT

What is the error?

Re: Qlikview for Developers - A solo exercise

Anonymous — Thu, 05 Apr 2018 03:21:50 GMT

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

Re: Qlikview for Developers - A solo exercise

shiveshsingh — Thu, 05 Apr 2018 10:35:28 GMT

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

Re: Qlikview for Developers - A solo exercise

Anonymous — Fri, 06 Apr 2018 03:13:25 GMT

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

Re: Qlikview for Developers - A solo exercise

Anonymous — Fri, 06 Apr 2018 04:51:02 GMT

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

Re: Qlikview for Developers - A solo exercise

shiveshsingh — Fri, 06 Apr 2018 17:49:51 GMT

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

Re: Qlikview for Developers - A solo exercise

shiveshsingh — Fri, 06 Apr 2018 17:51:15 GMT

Can u share QVD?

Re: Qlikview for Developers - A solo exercise

Anonymous — Sat, 07 Apr 2018 05:11:56 GMT

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?

Re: Qlikview for Developers - A solo exercise

kakani87 — Sat, 07 Apr 2018 05:42:43 GMT

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

Re: Qlikview for Developers - A solo exercise

Anonymous — Sat, 07 Apr 2018 11:17:04 GMT

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

Re: Qlikview for Developers - A solo exercise

kakani87 — Sat, 07 Apr 2018 12:25:20 GMT

Something like this?

Re: Qlikview for Developers - A solo exercise

Anonymous — Sat, 07 Apr 2018 12:47:10 GMT

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

Re: Qlikview for Developers - A solo exercise

shiveshsingh — Sat, 07 Apr 2018 16:26:38 GMT

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

Re: Qlikview for Developers - A solo exercise

shiveshsingh — Sat, 07 Apr 2018 16:27:46 GMT

use a pivot table, and drag month column to horizontal

Re: Qlikview for Developers - A solo exercise

Anonymous — Sat, 07 Apr 2018 16:44:51 GMT

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

Re: Qlikview for Developers - A solo exercise

shiveshsingh — Sun, 08 Apr 2018 02:31:39 GMT

Glad to know it worked