topic Re: Join Problem in QlikView

Join Problem

pgalvezt — Tue, 27 Nov 2012 13:30:41 GMT

Hello, Im going to try to explain my model: I have many tables with two keys Periodo and CodComer. Each table has Different period names and cod comer Names so I have had that join them (Union Table) Everything works fine but when I do clic over castigos my pivot doesn't show anything. I attached my modelo with reducting data. If you need more information please let me know.

Thanks!

Re: Join Problem

pgalvezt — Tue, 27 Nov 2012 13:57:16 GMT

I left another sample. Now the dimmension appears in another column.

Thanks!

Re: Join Problem

pgalvezt — Tue, 27 Nov 2012 14:20:51 GMT

Any Help?

Thanks!

Re: Join Problem

pgalvezt — Tue, 27 Nov 2012 14:54:15 GMT

Anyone?

Thank you!

Re: Join Problem

tanelry — Tue, 27 Nov 2012 15:55:31 GMT

The sample QVW seems to be protected by section access, could not open.

Re: Join Problem

pgalvezt — Tue, 27 Nov 2012 16:58:51 GMT

Sorry. I took off the Access.

Re: Join Problem

pgalvezt — Tue, 27 Nov 2012 17:36:11 GMT

Please let me know if you could open the QlikView File.

Thank you!

Re: Join Problem

pgalvezt — Tue, 27 Nov 2012 18:40:38 GMT

Anybody can help me with this. I really stuck I changed all the formats date that I know.

Thanks!

Re: Join Problem

Tue, 27 Nov 2012 19:06:13 GMT

Hi pgalvezt,

Just a thought can you try linked dimensions or linked keys instead of the common joins.

I think some thing is messed up in your joins which is causing you issue in retreiving data.

hope it helps

thanks

Meher

Re: Join Problem

tanelry — Tue, 27 Nov 2012 19:45:38 GMT

Look at table viewer and preview the tables: you see that Periodo in the Castigo table is formatted as number, but in other tables it is formatted as date.

You should force same format in each table, at least inside autonumber() clause.

I recommend to use this pattern:

AutoNumber(CodComer & '_' & num(Periodo)) as @Id

instead of:

AutoNumber(CodComer & Periodo) as @Id

Re: Join Problem

pgalvezt — Tue, 27 Nov 2012 20:44:08 GMT

Its the excel format. But 2 months gives wrong data. Periodo appears like Ene 2011. meanwhile Periodo_castigo Appears like 40285

I Left MonthName(Date(FECHA -1,'MMM-YYYY')) as Periodo_Castigo But Doesn't work.

Any Ideas?

Re: Join Problem

tanelry — Tue, 27 Nov 2012 21:30:28 GMT

It is @Id field that causes the problem. I gave you solution in my last post. Revise all AutoNumber() instances in your script accordingly.

Re: Join Problem

pgalvezt — Tue, 27 Nov 2012 22:25:29 GMT

Thank you but doesn't work finally I had to edit the excel file.

Thank you all of you!