topic Crosstable from a Binary in QlikView

Crosstable from a Binary

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

Hi,

I have a table from a binary load that goes more or less like Image 1 and I would like to order like Image 2 (Gross Salues, Returns, etc), but I'm not sure how the syntax of "crosstable" would work as there is a field ("Period Type") in the middle.

Thanks in advance.

(Image 1)

(Image 2)

Re: Crosstable from a Binary

sunny_talwar — Tue, 01 Aug 2017 02:20:31 GMT

Lets assume the table is called Table1... you can do like this

CrossTable:

CrossTable(Item, Value)

LOAD Period,

[Gross Sales],

[Returns],

[Total Off Invoice],

[Rebates],

[BillBacks],

[Co-op]

Resident Table1;

DROP Table Table1;

Re: Crosstable from a Binary

jonathandienst — Tue, 01 Aug 2017 04:54:09 GMT

Or if you would like to keep [Period Type]:

CrossTable:

CrossTable(Item, Value, 2)

LOAD Period,

[Period Type],

[Gross Sales],

[Returns],

[Total Off Invoice],

[Rebates],

[BillBacks],

[Co-op]

Resident Table1;

DROP Table Table1;

Re: Crosstable from a Binary

julioarriaga — Tue, 01 Aug 2017 13:16:43 GMT

If I could mark two posts as correct answers, I would . Thank you for your input, this is also correct.