Discussion Board for collaboration on QlikView Scripting.
I am trying to load data using cross table.
I've used qvd for data load and my data looks like
In Cross table Name and Product fields i select for the Qualifier and the other columns as Attribute fields.
Instead of this I want to use Name, Product, City and Country as Qualified field, Jan amount and Feb amount as attribute fields.
I want to load data
Please help me out,
Thanks in advance
CrossTable(Month, Data, 4)
Try what Sunny suggested you...
Another workaround is like say Jugad?
Insert all the attribute field as last column in excel as with above mentioned structure you would not be able to Qualify City & country.
try this at script, slightly reorder the columns..
(ooxml, embedded labels, table is Sheet1);
Thanks you so much Sunny and Balraj to give response.
It Works. Thanks once again.
Thanks you so much Sunny & Balraj.