Crosstable Blanks

[kevbrown]

I have an excel crosstable that is half populated. Any unpopulated cells I don't want to bring into Qlikview. Is there a way of excluding  them and only bringing in populated cells. I've tried where Column 2 is > 0 but then that doesn't work for column 3,4,5 etc

[avinashelite]

please share the same data ...

[kevbrown]

I can't seem to  add an attachment

[avinashelite]

1. Click on reply

2. At the right top you will see an option "Use Advanced editor" click on it

3.Now at the bottom right you will see the option "attach"

[kevbrown]

Thanks

[MK_QSL]

CrossTable(Type,Value)

LOAD F1,

     [Lieder 1],

     [Lieder 2],

     [Line 3],

     [Line 4],

     [Line 5],

     [Line 6],

     [Line 7],

     [Line 8],

     [Line 9],

     [LR Traywash],

     [Line 11],

     Preparation,

     [L/R Packing],

     [H/R Bacon Room],

     [L/R Bacon Room],

     [H/R Salad Wash],

     [L/R Salad Wash],

     [Bread Area],

     [Bay 6 & Sanitiser],

     Despatch,

     Hygiene

FROM

Example.xls

(biff, embedded labels, table is Sun$);

[avinashelite]

to eliminate the null records add one more step like this

Temp:

CrossTable(Type,Value)

LOAD F1,

     [Lieder 1],

     [Lieder 2],

     [Line 3],

     [Line 4],

     [Line 5],

     [Line 6],

     [Line 7],

     [Line 8],

     [Line 9],

     [LR Traywash],

     [Line 11],

     Preparation,

     [L/R Packing],

     [H/R Bacon Room],

     [L/R Bacon Room],

     [H/R Salad Wash],

     [L/R Salad Wash],

     [Bread Area],

     [Bay 6 & Sanitiser],

     Despatch,

     Hygiene

FROM

Example.xls

(biff, embedded labels, table is Sun$);

NOCONCATENATE

Result:

LOAD *

resident

Temp

where len(trim(Value))>0;

Drop table Temp;

• Crosstable Blanks