topic Re: Re: Cross table - Help with fields in QlikView

Cross table - Help with fields

helen_pip — Mon, 01 Oct 2012 09:34:41 GMT

Hello,

Could someone kidnly help me with understanding how I can build a cross table from a already stored qvd file

I appreciate that you may not have the access to my qvd file, but amd looking to achieve a cross table which would look something like this

	Apr	May	Jun
Red	5	7	9
Yellow	10	11	12
Blue	7	5	6

I have attached the qvw document and was wondering of someone could help me achieve the above layout through a cross table LOAD

Kind Regards

Helen

Re: Cross table - Help with fields

Anonymous — Mon, 01 Oct 2012 10:01:01 GMT

Is there a reason why you want a crosstable in the table itself? If it's just for presentation purposes in the UI then it will be easier to use a Pivot Table and set the Month dimension as horizontal instead.

Re: Cross table - Help with fields

Anonymous — Thu, 22 Aug 2013 04:42:03 GMT

Hi Helen,

Im in need of the same layout, if yu got the solution can yu help me out.....?????

Re: Re: Cross table - Help with fields

vikasmahajan — Thu, 22 Aug 2013 04:54:27 GMT

Hii

Cross table is very simple 2 way you can load information

1. By wizard

2 By Manully.

Please find attachment of detailed qvw and supporting for cross tables.

Hope this help you , Best Of Luck.

Vikas