I work for an apparel company and I have a request from the Finance department for a QlikView report which should look like the table below. The issue I am having when I create this table is the first three expressions above the black line in the table use scheduled delivery date to calculate their totals, while the expressions below the black line use actual shipped date to calculate their totals.This is an issue for the date dimension placed at the top of the table as I can only pick one date for the dimension (scheduled delivery date or actual ship date). Is there a way to create dynamic date dimension that can switch between the two dates depending on the expression below or some way to create a static dimension which will display the months of a year yet allows me to call out the specific dates within the expressions? Also to be clear, there is no math that gets you from Booked Orders @ Net to Invoiced Shipped, they are independent of each other in this situation. This all stems from the requirement that these expressions need to appear in one table together. I hope I explained my issue well enough.
Jan-18 Feb-18 Mar-18
Booked Orders 756,000 800,000 785,000
(Front End Discounts) (6,000) (10,000) (7,000)
Booked Orders @ Net 750,000 790,000 778,000
Invoice Shipped 687,000 720,000 705,000
(Returns) (50,000) (54,000) (52,000)
(Credits) (100,000) (115,000) (107,000)
Net Sales 537,000 551,000 546,000
***Please keep in mind there is no need for the black line, I used this purely to explain the date issue.
