Discussion board where members can get started with QlikView.
i want to a table with "STATE/COUNTRY" wise "Product_Short_Name" wise monthly "Sales_Qty" Vs. "Forecst_Qty" .
to achieve this my data is as follows
i dont know how to map them, can anyone help me on script part?
May be try this? Rename the fields in Sales table accordingly. And i used Party_Code/PARTY_No as joining key.
(html, utf8, embedded labels, table is @1, filters(
Remove(Row, Pos(Top, 1))
LOAD [CICS/Party CICS] AS SalesPartyCICS,
[Month/DATE] AS SalesDate,
[Product/IM_CODE] AS SalesProdIMCode,
F6 AS Sales_St_Country
(html, utf8, embedded labels, table is @3, filters(
May be I am confuse to get the output, but It would be great help if you could suggest me how to get this output –
Out of these three tables :-
01/06/2018 12:00:00 AM
01/07/2018 12:00:00 AM
01/08/2018 12:00:00 AM
01/04/2018 12:00:00 AM
21/06/2018 12:00:00 AM
03/07/2018 12:00:00 AM
09/08/2018 12:00:00 AM
14/04/2018 12:00:00 AM