Join Problem

[pgalvezt]

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!

[pgalvezt]

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

Thanks!

[pgalvezt]

Any Help?

Thanks!

[pgalvezt]

Anyone?

Thank you!

[tanelry]

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

[pgalvezt]

Sorry. I took off the Access.

[pgalvezt]

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

Thank you!

[pgalvezt]

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

Thanks!

[#9]

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

[tanelry]

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