Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Sales Restriciton

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

Tags (4)
1 Reply
Not applicable

Re: Sales Restriciton

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.

Community Browser