Sales Restriciton

[#1]

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

[#2]

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.