topic Re: QLIKVIEW LOOPS PROBLEM in QlikView

QLIKVIEW LOOPS PROBLEM

wale_martins — Fri, 26 May 2017 12:17:37 GMT

Hi all,

Could someone solve my problem with that loop (cod_producto)?

Thank you in advance!

Re: QLIKVIEW LOOPS PROBLEM

m_woolf — Fri, 26 May 2017 16:30:00 GMT

In the load script for BD_PRECIO,

Cod_Producto as BP_Cos_Producto (or any other name that doesn't match another field)

Re: QLIKVIEW LOOPS PROBLEM

wale_martins — Mon, 29 May 2017 06:00:40 GMT

Thank you for your quick response. I had already done that.... the problem is that when I try to filter a cliente from BD_Cliente I can't get the correct precio from BD_Precio (I get all precio results)

Any other solution?

Thank you very much m w

Re: QLIKVIEW LOOPS PROBLEM

Digvijay_Singh — Tue, 30 May 2017 05:03:36 GMT

Somehow you need to break the loop and the exact location where we should break the loop is normally indicated from business meaning of the fields.

If Cod_Producto in BD_PRECIO is not the right field to rename then what if we rename Grupo_Descuento... in BD_DESCUENTO to break the loop?

You may want to build star schema model by concatenating or joining tables to simplify your data.

Re: QLIKVIEW LOOPS PROBLEM

wale_martins — Thu, 01 Jun 2017 10:33:50 GMT

Thank you very much Digvijay Singh

The problem is that I can't either break the loop in BD_DESCUENTO. I need both tables to be related with cod_producto.

Table DESCUENTO brings me all the discounts that each "cod_producto" have and table PRECIO brings me all the prices that each "cod_product" also have...

I have to change the script... but I don't know how...

Regards

Wale

Re: QLIKVIEW LOOPS PROBLEM

wale_martins — Fri, 09 Jun 2017 05:59:59 GMT

Dear All,

I've finally solved my problem, creating a linktable. I don't know if it's the best solution, but know I'm able to get product prices and also product discounts.

LinkTable:

Load

Cod_Producto,

Grupo_Precio_Venta

resident BD_PRECIO;

Concatenate(LinkTable)

Load

Cod_Producto,

Grupo_Descuento

resident BD_DESCUENTO;

Regards

Wale