topic Re: Crosstable in QlikView

Crosstable

polisetti — Fri, 04 Oct 2013 18:16:15 GMT

I have a problem getting while using Crosstable .I Attached a Xl file which containing the data sample .Please give example how to use crosstable for this data

Re: Crosstable

swuehl — Fri, 04 Oct 2013 18:19:21 GMT

I think you just need to transpose your table:

Directory;

LOAD [Date of sales],

[Employee's last name],

[Region of sales],

[Number of sales]

FROM

Coomunity.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Col, Pos(Top, 1)),

Transpose()

));

Re: Crosstable

polisetti — Sat, 05 Oct 2013 05:48:44 GMT

Hi Swuehi ,

Thank you for your Response ,I got the output ...But can we use crosstable in this scenario...

Re: Crosstable

Gysbert_Wassenaar — Sat, 05 Oct 2013 07:11:05 GMT

No, use the transpose function like swuehl said.