Discussion Board for collaboration on QlikView Scripting.
How can i compar between "forecast amount" in the forecast table
to "amount" in sales amount table?
the common fields are: mont in forecast table. invoicedatein sales amount table.
Go to Solution.
First you need to join your two tables in the load script, by adding the lines below in bold brown.
Give that a go & if needed post the revised qvw and ask for suggestions.
Monthname( InvoiceDate ) as [YearMonth] ,
(ooxml, embedded labels, table is [Sales Actual]);
monthname ( date ( date# ( text (num ( Month , '00' )) & Year , 'MMYYYY') ) ) as [YearMonth] ,
(ooxml, embedded labels, table is Forecast);
Best Regards, Bill
Thank you for the ansuer. works good.
How can i make group by on the sales?
I want to compare total sales by month-
to compare the total sales of january to the total forecast of january etc.
Glad to hear you are on the road.
For your question above, why not you start a new discussion and attach your revised qvw to it.