topic Crosstable qualifier fields selection in QlikView

Crosstable qualifier fields selection

renjithpl — Tue, 16 Nov 2010 08:07:32 GMT

Hi all,

I have a table like below:

Name	Field1	Field2	Field3	Country
ab	xx	mm	ss	asd
cd	xy	nn	pp	efg
ef	zy	oo	rr	hig

I used crosstable to feed in my data,

In the crosstalbe template there is a qualifier fields, if i select 1 the name field will change pink and rest of others will be in green.
I want Name, Country as separate fields.
Field1, Field2 and Field3 as One field.

so totally 3 fields, but i dont know how to give country in qualifier fields.

if i give 2 in qualifier fields then Name and Field1 is changing pink, i dont want that. See the attachment too.

Please help me regarding this. Thanks in advance

Ranjit

Crosstable qualifier fields selection

deepakk — Tue, 16 Nov 2010 08:15:12 GMT

YOu can ignor the wizard and write the code manually in below way.

crosstable(Field,Value,2)

Load

Name,

Country,

Field1,Field2,

Field3 from Test;

Crosstable qualifier fields selection

renjithpl — Tue, 16 Nov 2010 08:22:34 GMT

Cool, deepak ! it worked, thanks a lot. 🙂

Crosstable qualifier fields selection

renjithpl — Tue, 16 Nov 2010 08:45:03 GMT

HI deepak,

is it possible if i want one more group

Say my table is like

Name	Field1	Field2	Field3	Country	Cat1	Cat2
ab	xx	mm	ss	asd	5	1
cd	xy	nn	pp	efg	6	2
ef	zy	oo	rr	hig	7	3

As per your code i got 3 fields (Name, Country and Fields).

So if i want Cat1 and Cat2 as Categories, how should i write the code.
so totally i want 4 fields. Is it possible. ?

Thanks