topic Create Records in QlikView

Create Records

qlikviewaf — Wed, 13 Sep 2017 07:35:13 GMT

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

tresB — Wed, 13 Sep 2017 07:43:54 GMT

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

qlikviewaf — Wed, 13 Sep 2017 07:45:43 GMT

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?

tresB — Wed, 13 Sep 2017 07:53:05 GMT

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 — Wed, 13 Sep 2017 07:59:55 GMT

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

qlikviewaf — Wed, 13 Sep 2017 08:15:27 GMT

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

tresB — Wed, 13 Sep 2017 08:40:43 GMT

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