Create Records

[qlikviewaf]

I have some formula in my script that works well only if i have invoice for every single day.

Example:

if i want to count the working day for July, i have my calendar configured with a field "WorkingDay", if this latter is = 1, is a working day.

If i select all July days, but for 3 working days i don't have any invoice, the total working day for will not be correct.

Question: there's any way to select days regardless the fact that an invoice_date is not available for that specific day?

Thank you

[tresesco]

You could probably join the tables to create all the dates in the fact table itself. Please check:

How to populate a sparsely populated field

Generating Missing Data In QlikView

[qlikviewaf]

I was thinking to left join the FACT TABLE (containing sales data) with the Calendar in order to have calendar as fact table.

Could make sense?

[tresesco]

Left? Shouldn't it be right? Anyway, that can change on table positioning. Like:

FactTable:

Right Join

MasterCalendar:

Because you would need all dates from master calendar.

[qlikviewaf]

and what if i concatenate the calendar qvd file with the sales fact table?

[qlikviewaf]

Would it be possible to create all invoice date for all "Region" / Product Category / Area?

means that invoice date 25/12/2017 should be available for:

Region: Europe, Asia, etc

Product Categori: Vehicle, Truck, etc

Area: EMEA, APAC

is somethign possible? so for 1 invoice date i should have multiple rows

[tresesco]

Since your calendar would not have metadata, that would not be of much help I guess.