topic Re: Common calender in QlikView

Common calender

Sun, 14 Oct 2012 14:18:56 GMT

Hi,

I want to create common calender for my QV app. Acually I have an app in that there are 4 dimension tables and 1 fact table. So different date fields are there

for analysing each KPI's. So Can i get any tips on creating common calender. Please suggest.

Regards

Suneela

Re: Common calender

kaushiknsolanki — Sun, 14 Oct 2012 14:38:51 GMT

Hi,

Would you please share those tables with their field names, this will help us to think about solution.

Regards,

Kaushik Solanki

Re: Common calender

Sun, 14 Oct 2012 14:47:11 GMT

There is 1 dimension table and 1 fact table:

1)StartTime and FinishTime - Dimension table field

2)ScheduledStartTime and ScheduledFinishTime and Audit_timestamp - Fact table fields

I have 20111 and 2012 date and time.

Re: Common calender

kaushiknsolanki — Sun, 14 Oct 2012 14:57:17 GMT

Could you please describe what generally you want to do by linking them all to one calendar.

Regards,

Kaushik Solanki

Re: Common calender

Sun, 14 Oct 2012 15:12:23 GMT

Hi,

I have some KPI's to calculate and analyse with respected fields.

For exp:

1)I have to calculate a KPI which involves AuditTimeStamp field only- This one i want to analyse by this field only.

2)Other KPI by schedulestart and finish time of dimension table.

3)Next KPI by start and finish time of dimension table.

Now to analyse I am using separe fields for respective KPI's. So now I want to link altogether and analyse with single filed(By common calender).

KPI 1, KPI 2, KPI 3-Currently showing in different sheets as these are not dependent on each other. So want to show in single sheet with single filed So that

it can filter accordingle.

As I am not getting how to link by extracting each fileds and manipulate please suggest.

Re: Common calender

kaushiknsolanki — Sun, 14 Oct 2012 15:32:52 GMT

Will you send sample data with few records say aroung 100

Regards,

Kaushik Solanki