topic Re: bug in table box? in QlikView

bug in table box?

stefano_marson — Thu, 31 Jul 2014 12:03:32 GMT

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

Re: bug in table box?

joshabbott — Thu, 31 Jul 2014 12:22:56 GMT

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

Re: bug in table box?

joshabbott — Thu, 31 Jul 2014 12:27:51 GMT

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

Re: bug in table box?

stefano_marson — Thu, 31 Jul 2014 12:31:29 GMT

I broke QlikView!

Re: bug in table box?

Anonymous — Thu, 31 Jul 2014 13:14:37 GMT

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!