topic Re: Crosstable doesn't work in QlikView

Crosstable doesn't work

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

Hi guys,

I have an exel file like this:

A	B	C	D	E	F	G	H	I	J	K	L
48	843	3156	15	481	548	484	218	15	128	412	451

and I want this:

So I'm using Crosstable to do this:

Crosstable (Type,Value, 0)

Load A,

From ...

but it doens't work, and the result is a table equal to the source.

I don't understand why.

YoussefBelloum — Thu, 01 Mar 2018 09:00:26 GMT

Hi,

yesterday I was stuck on doing a Crosstable without a qualifier column (like what you have here).

try to take your file and insert another column before the column A, insert any value on it.

when doing the crosstable on the Wizard, choose the new column as the qualifier column.

at the end of the script, you can drop this field.

drop field field_name from table_name;

Anonymous — Thu, 01 Mar 2018 09:12:48 GMT

Ok, this solution works, thanks

YoussefBelloum — Thu, 01 Mar 2018 09:16:21 GMT

You're welcome !

Good luck