topic Re: CrossTable creating Orphans, bug? in QlikView

CrossTable creating Orphans, bug?

optiknerd — Tue, 26 Jan 2016 15:24:39 GMT

Hi All,

Just running through some examples laid out in Qlikview 11 for Developers and am getting an odd result while trying to work through the crosstable example in Chapter 9. I have done cross tables many times before and it has worked like a charm but this time, I keep getting orphan tables that equate to the fields that are being uncrosstabled (Months) being produced.

I am fairly certain that the script below is correct because the table that it creates contains all the right info. The month field is created properly. But there are these orphan tables that just won't go away.

CrossTable:

CrossTable(Month, No_Employees, 9)

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 [Employment Statistics - CrossTable.qvd] (qvd);

See Tableview below.

Is this a known bug?

Is there a list of known bugs by version that one can check for stuff like this?

My version is 11.20.12904.0 SR12 64 Bit.

Thanks in advance for your help.

Cheers
KH

Re: CrossTable creating Orphans, bug?

PradeepReddy — Wed, 27 Jan 2016 05:41:21 GMT

I tried it using "Inline Load" and getting results as expected.

I am using 11.20 SR5, not sure about SR12

Can you try Inline Load once in SR12, so that can check the problem.

Re: CrossTable creating Orphans, bug?

jonathandienst — Wed, 27 Jan 2016 05:46:23 GMT

I have never seen this. Is that the complete load script? How many rows and what data is in the orphan tables?

Re: CrossTable creating Orphans, bug?

rajeshforqlikvi — Wed, 27 Jan 2016 05:51:39 GMT

Use 10 instead of 9.

Re: CrossTable creating Orphans, bug?

marcus_sommer — Wed, 27 Jan 2016 06:39:05 GMT

See here: Explain the orphan table bursting

- Marcus

Re: CrossTable creating Orphans, bug?

optiknerd — Wed, 27 Jan 2016 17:42:11 GMT

Hi Rajesh,

I tried 10 instead of 9 but got the same resulting orphan tables.

Both of the work arounds in Marcus' doc worked though.

Re: CrossTable creating Orphans, bug?

optiknerd — Wed, 27 Jan 2016 17:43:06 GMT

Hi Marcus,

Thanks for the doc. Both work arounds worked perfectly!

Re: CrossTable creating Orphans, bug?

optiknerd — Wed, 27 Jan 2016 17:50:59 GMT

Hi Jonathan - yes this is the complete script.

The work arounds that Marcus sent eliminated the problem.

However, I ran the script again to check on the rows and data in each orphan that you asked about.

Each orphan has the data related to the month it cross tabbed.

I got an error message that may be part of the cause.

I am using Personal Edition with sample apps and QVDs that come with Qlikview for Developers.

By the looks of this message, I appear to have corrupted the embedded license in the sample files.

Thanks for your help!

Re: CrossTable creating Orphans, bug?

optiknerd — Wed, 27 Jan 2016 17:52:30 GMT

Hi Pradeep,

The doc from Marcus provided two workarounds that both work.

I would test with SR12 but have my system working fine and don't want to risk upgrading just yet.

Cheers,

Kevin

Re: CrossTable creating Orphans, bug?

aritra_saha — Thu, 28 Jan 2021 17:44:51 GMT

Use where1=1;

in he load statement