topic Database design with multiple date fields in QlikView

Database design with multiple date fields

Thu, 23 Dec 2010 17:15:18 GMT

Hi,

In Current scenario we have a table with around 150 Columns and minimum of 10 date fields. And this table is multi tenant since multiple customers data is stored.All the date fields are stored in different columns not as single column. I need to show the charts based on Yearly,Weekly,Monthly ,Daily,Hourly based on every date fields.

Since data size is huge i cant use the cross table to convert the rows in to columns to ensure that all the date columns in to single column.

How to proceed on this?????

Database design with multiple date fields

vgutkovsky — Thu, 23 Dec 2010 21:25:20 GMT

What do you mean that the chart has to be based on every date field? Are all the dates identical? Do you want to have a cycle group of the dates?

Database design with multiple date fields

Fri, 24 Dec 2010 08:37:13 GMT

Hi Vlad,

I will be having one chart by Recived date, one chart by modified date,one chart by Assigned date. In this scenario i should have only one date selection list box based on which all the charts should get changed accordingly....

Database design with multiple date fields

sunil2288 — Fri, 24 Dec 2010 09:36:29 GMT

HI XXX,

You should go with creating a single calender. And you need to give the link (Reference) to all the date fileds you do have in the application..

So that refering to a single date selection whole of your application get referred each time.

Regards

Sunil

Database design with multiple date fields

vgutkovsky — Fri, 24 Dec 2010 23:04:10 GMT

I agree with Sunil. Otherwise you would have to create a date island and refer to that in every expression--this would slow down performance considerably.