topic Re: Linking a excel file in QlikView

Linking a excel file

Wed, 28 Aug 2013 07:55:39 GMT

i have a main data model for which i need to map this attached excel.

Main QVD

staff name

call date

.....

excel file

Engineer name

roastermonth (which is in different columns)

how do i map this both field to find the no. shifts on each engineer in particular month.

VishalWaghole — Wed, 28 Aug 2013 08:45:39 GMT

if your staff name is equal to engineer name(field from your excel) then

you can link staff name = engineer name.

but for that your both fields should be unique.

Thanks

Vishal.

michael_maeuser — Wed, 28 Aug 2013 08:59:44 GMT

You also need to load the excel as a crosstable, just in case you forgot that.

Michael

Wed, 28 Aug 2013 09:24:27 GMT

i have done the crosstable and linked the staff name but how to link roster month to my master calender

michael_maeuser — Wed, 28 Aug 2013 09:38:43 GMT

i guess you have a "Date" field or s.th. similar in you calendar and you have the problem of a circular reference if you link the excel table to it?

in that case, i think the easiest way is to concatenate your 2 fact tables to one fact table and create a source field.

e.g.

Fact:

load

staff name

call date,

'QVD' as Source

.....

concatenate (Fact)

Load

Engineer name

roastermonth (which is in different columns),

'Excel' as Source

in your expressions you can seperate the data in set analysis e.g. sum({<Source={'Excel'}>} ..)

Wed, 28 Aug 2013 12:32:58 GMT

But need to map roster month to calender to filter the data on month on month wise. to find the engg productivity.