Discussion Board for collaboration related to Creating Analytics for QlikView.
I have attached 3 tables,
Item Sales contains Item, store and sales per week.
Item Budget contains Item, area and weekly budget,
Store Info contains store and its area.
Also, column week in first 2 tables has totally different value.
What script should I use to load them correctly? Please share the script instead of qvw as I could not open 3rd party's qvw file. thanks.
Go to Solution.
Correctly depends on your requirements
LOAD [Item #],
replace(Week, '#', '') as Week,
(biff, embedded labels, table is Sheet1$);
left join (Sales)
LOAD [Store #],
replace(Week, 'Week', '') as Week,
'Budget' as Table