topic Re: Data Integration from external excel table in QlikView

Data Integration from external excel table

Finance19 — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I got two field in my qvw: SalesObjective and SalesReal

The expression SalesReal/SalesObjective gives the % of realization (lets say 93%)

In a separate table (on excel) I got a coeficient linked to this % or realization (e.g. 0.9)

How can I integrate the data of the second table in my qvw so that when I calculate SalesReal/SalesObjective in my expression it gives me the coeficient 0.9 ?

Thank you !

Baptiste

Re: Data Integration from external excel table

its_anandrjs — Tue, 15 Jan 2019 11:58:00 GMT

Hi,

You have to link this data with your fact table to get properly effective in a row.

Regards,

Anand

Re: Data Integration from external excel table

jonathandienst — Wed, 16 Jan 2019 07:15:38 GMT

You will need to round the ratio to link with another table. To get a value of 0.9:

Round(SalesReal/SalesObjective, 0.1)

Or use Floor() or Ceil() as appropriate