topic Re: CrossTable Help in QlikView

CrossTable Help

tahirkhalil — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have data as :

I like to use CrossTable while loading this XLS as:

Can someone suggest how to use CrossTable?

Regards,

sunny_talwar — Mon, 01 Aug 2016 10:49:08 GMT

I think what you might need is a Generic load:

But I suggest keeping the data as is and create a pivot table on the front end to view the data as your second table.

vinieme12 — Mon, 01 Aug 2016 10:50:01 GMT

I personally feel you can make best use of your existing data structure without making changes, this way your expressions will be simpler

tahirkhalil — Mon, 01 Aug 2016 11:00:55 GMT

Thank you Sunny & Vineeth,

In fact for some calculations, I need to modify the structure, secondly, I need to reduce the data rows in QVD.

Regards,

Tahir