topic Re: Help to solve this model relations!! in QlikView

Help to solve this model relations!!

Fri, 05 Jul 2013 23:34:33 GMT

Hi guys could some body please help me to solve this model?

Tanks!!

Re: Help to solve this model relations!!

Sokkorn — Sat, 06 Jul 2013 04:44:03 GMT

Hi,

Here is my suggestion:

[Objetivos]:
LOAD 
     IDPais                            AS [_IDPais],
     IDProducto                        AS [_IDProducto],
     IDProducto &'|'& IDProducto    AS [_Key], 
     IDPais, 
     IDProducto, 
     Mes, 
     Año, 
     Cantidad
FROM
[Info ejemplo cruso QV.xlsx]
(ooxml, embedded labels, table is Objetivos);
Left Join ([Objetivos])
LOAD
     IDProducto &'|'& IDProducto    AS [_Key],
     IDProducto, 
     IDCliente                        AS [_IDCliente], 
     IDPedido, 
     Cantidad                    as Cantidad_Ventas, 
     Fecha
FROM
[Info ejemplo cruso QV.xlsx]
(ooxml, embedded labels, table is Ventas);
Left Keep([Objetivos])
LOAD IDCliente    AS [_IDCliente], 
     Cliente,
     IDPais
FROM
[Info ejemplo cruso QV.xlsx]
(ooxml, embedded labels, table is Clientes);
Left Keep([Objetivos])
LOAD IDPais    AS [_IDPais],
     País
FROM
[Info ejemplo cruso QV.xlsx]
(ooxml, embedded labels, table is País);
Left Keep([Objetivos])
LOAD IDProducto    AS [_IDProducto],
     Producto
FROM
[Info ejemplo cruso QV.xlsx]
(ooxml, embedded labels, table is Productos);

See sample attached file.

Regards,

Sokkorn

Re: Help to solve this model relations!!

Mon, 08 Jul 2013 14:52:27 GMT

Hi Sokkorn

when you select the field "Pais" it does not work with the rest of fields.

Re: Help to solve this model relations!!

Mon, 08 Jul 2013 15:05:03 GMT

Hola Javier,

Remember in QlikView you can easily use CONCATENATE and JOIN tables.

Don't use opetrational model BUT decisional model

So i would rather JOIN clientes on Ventas, same with Produtos.

You don't need table Pais.

Don't forget to use MAPPING.

In your case, you may work with 1 or 2 tables

Chris

Re: Help to solve this model relations!!

Mon, 08 Jul 2013 16:06:58 GMT

Hi Javier

Not knowing your dataset I avoided using joins etc and went for a Linked Table approach.

See attached example.

Thanks

Zohaib