topic cross table in QlikView

cross table

Tue, 03 Apr 2012 10:05:55 GMT

how to remove 2 fields while loading table as a cross table?

cross table

Jason_Michaelides — Tue, 03 Apr 2012 10:43:25 GMT

Just don't define them in the load part of the Crosstable() function.

cross table

Tue, 03 Apr 2012 10:49:38 GMT

Hi,

Yes Jason is right.

When you do crosstable load script will be genearated for that, You can modify that script to suit according to your need.

So, if you want any field to not to be loaded in cross table then just delete that field from your load statement.

if it is still not clear then post your cross table load script.

cross table

Tue, 03 Apr 2012 11:22:35 GMT

Sheet3 :

CrossTable(Period, Data, 3)
LOAD *
FROM
[..\Excel\Nielsen_Output_Feb12.xls]
(biff, embedded labels, table is WSP_Sheet3$, filters(
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null))
));

this is my cross table . and in Data i applied transpose and it consists of 5 columnsw which i need to transpose but out of these 5 fields i dont want 2 fields then wt to do?

cross table

Jason_Michaelides — Tue, 03 Apr 2012 11:25:04 GMT

Instead of LOAD * use LOAD Field1, FIeld2, Field3 etc...

That way you can choose which fields to include.

cross table

Tue, 03 Apr 2012 11:32:43 GMT

Hi,

Yes, Don't use * rather always list field names which you want to load. If you want to load all the field names then list all the field names.

This is a good development practice and using * can lead you sometimes into problems hard to debug.

To list down all the fields, when you use file wizard to load the data, at the last point you will see a checkbox of

Load All(*), it seems that you have checked it, just uncheck this checkbox then you will be able to see all the field names and then remove the fields which you don't want to load.

To reach to the last point, keep clicking the next in your file wizard and you will see this option when next button becomes unavailable.

...

Ashutosh

cross table

Wed, 04 Apr 2012 01:56:46 GMT

Sheet3 :

CrossTable(Period, Data, 3)
LOAD *
FROM
[..\Excel\Nielsen_Output_Feb12.xls]
(biff, embedded labels, table is WSP_Sheet3$, filters(
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null))
));

this is my cross table . and in Data i applied transpose and it consists of 5 columnsw which i need to transpose but out of these 5 fields i dont want 2 fields then wt to do?

cross table

Wed, 04 Apr 2012 02:05:24 GMT

hi Ashutosh

i got that option load * . and its unckecked but at the same time m nt able to remove fields from that table. and after selecting load * it is nt possible to remove that field... and clickin on finish wil showes result like after selecting Load *. please help me regarding that.......

cross table

Wed, 04 Apr 2012 02:06:25 GMT

yes i got it........ thanx a lot............