topic Crosstable question in QlikView

Crosstable question

Thu, 11 Jun 2009 04:53:06 GMT

Hi there

I have an excel file with several colums for different categories of information repeated for a certain number of years.

For exemple

ID - PRODUCT - CAT_A_Y04 - CAT_A_Y05 - CAT_A_Y06 - CAT_B_Y04 - CAT_B_Y05 - CAT_B_Y06

and so on.

I'd like to obtain something like:

ID - PRODUCT - YEAR - CAT_A - CAT_B

How should I do?

Thanks

-g

Crosstable question

Anonymous — Thu, 11 Jun 2009 06:58:26 GMT

g,
Because you have two sets of fields - A, and B - you can use two consequent crosstable loads. First time only A-fileds, second, only B-fields. After that, join into one table if needed.
Maybe there is a better way that I don't know yet...

Crosstable question

Thu, 11 Jun 2009 14:06:04 GMT

Hi,

Here you go.... !

See the attachment.

Please let me know if it works

Cheers

- Sridhar

Crosstable question

Thu, 11 Jun 2009 19:00:54 GMT

Hi,

Sry, There was some error in my previously posted application.

No, here is the working version.

- Sridhar

Crosstable question

Fri, 12 Jun 2009 03:15:58 GMT

Hi Sridhar I have tested with a new set of colums and all wen fine.

searching around in the forum I found a piece of the code you used to trasnform the cross table as I wonted.

Thanks a lot for your help.

- giulio

Crosstable question

Sun, 14 Jun 2009 14:57:48 GMT

Dear , Please share how did you do? Thanks

Crosstable question

Sun, 14 Jun 2009 22:04:48 GMT

in the answer gave me by Sridhar you can download the file answering my question.