bug in table box?

[stefano_marson]

Hi,

I developed a .qvw file with QlikView Desktop release 11.2. You can see the document in attach.
There are two tables:
FATTI with 69 records (66 distinct records)
PREVISIONI with 37635 records (10942 distinct records).

KEY field associates tables.

Values in FATTI.KEY and in PREVISIONI.KEY have not intersection.

I add a table box "FATTI e PREVISIONI" with all table fields.

I thought that the "FATTI e PREVISIONI" had 11008 record: 66 distinct records by FATTI and 10942 distinct records by PREVISIONI. Instead, the table shows 10942 distinct records, those in the table PREVISIONI.

What is the matter?

Thanks in advance

Regards

[joshabbott]

Very interesting, the VAL_PREV seems to be the field that does it.  If I add all the fields to the table box except that one, the 'FATTI' table fields are there, but as soon as VAL_PREV is added, those go away

[joshabbott]

Wow, that's strange, I don't think I've ever seen that before.  I have a feeling part of the hint may be if you set the 'Omit Rows Where Field is Null' on Key, nothing is returned, just can't think of why it would do that

[stefano_marson]

I broke QlikView!

[Anonymous]

The problem is in the visualization of the table and in the export on excel: e.g. if you select a single value for VAL, your table is updated and shows the row (which is "hidden" without selections). Very strange!