topic Re: How to create hour dimension for different tables? in QlikView

How to create hour dimension for different tables?

Fri, 01 Apr 2016 10:26:39 GMT

Hello all.

I’m developing a dashboard in Qlikview and facing a few problems in creating an hour dimension.

I have to tables: Sales and Employees.

Both tables have a datetime field, but are completely different. I have no relation between the two tables.

The problem is that I have to create a table chart dimensioned by hour with two columns: Sales and HR Costs.

How can I create a unique dimension hour for my two tables? Any suggestions?

Thank you!

Gysbert_Wassenaar — Fri, 01 Apr 2016 11:22:41 GMT

Give the datetime fields the same name and convert the datetime values if necessary to the same timestamp format.

sunny_talwar — Fri, 01 Apr 2016 11:23:50 GMT

You can try to combine the idea from these three blogs

Kushal_Chawda — Fri, 01 Apr 2016 11:24:35 GMT

Link both the Tables on Date Field

Rename Sales Date & HR Table date with common name so that both the table will be linked on Date.

Now You can create the Master Calender using this Date in which you can also create the Hour Field