Discussion Board for collaboration on QlikView Scripting.
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 !!
Look here for a way to handle multiple dates: Canonical Date