Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a scenario where one set of data deals with one date field and other set of data deals with another date field.
I hope this can be met with two different ways.
1.concatenate both the set of data(to create fact table) and joined this to the Calendar table.
2.Create the calendar fields by combining both the different sets of data with different date fields.
Can someone please tell me is Qlikview good at dealing with more rows(option 2) or is it good to deal with the traversing with a connected table(option 1)
Thanks you !!
Lalitha
Look here for a way to handle multiple dates: Canonical Date