Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am loading plan and sales data into Qlikview linking the two table with a deep enought key (year period, Customer, Item Number).
My issue is this: Once the data is loaded in The plan data is resticted to months that had sales for that particular Item. I need all the plan data to be shown, ireespective of sales,so I can draw the correct comparisons.
Any help would be much appreciated.
Richard
Hi,
to show all the dates u need to create a master calendar in ur data model which u will link with ur transactional date field.