topic Re: Straight Table is not displaying info correctly in QlikView

Straight Table is not displaying info correctly

Tue, 19 Mar 2013 09:44:53 GMT

Hi I have created a dummy example with 3 tables connected through some fields.

I have already removed Sinthethic Key creating a central table with common fields information

My problem is that when I select a Date, no info is displayed in "Origen" Straight Table and it should show the same rows as "Table Box"

I guess that the reason is that more than one record is found for each Date but,, how to solve it?

Thanks in advance.

Re: Straight Table is not displaying info correctly

Anonymous — Tue, 19 Mar 2013 09:47:47 GMT

Hi Tatiana,

Since your expression is only Origen, QlikView doesn't know which of the three values associated with your date that you want to show.

What would you like your table to look like?

Re: Straight Table is not displaying info correctly

Tue, 19 Mar 2013 09:49:41 GMT

Hi Johannes, I would like the 3 records to be displayed

Re: Straight Table is not displaying info correctly

Tue, 19 Mar 2013 09:59:26 GMT

Hi Tatiana,

If you simply want to display records (i.e. you don't want to do any calculations e.g. count the number of records), then the table box is what you need and not the straight table.

Straight table requires some sort of a calculation to be done. Try "Table box..." instead of "Chart...".

Re: Straight Table is not displaying info correctly

pennetzdorfer — Tue, 19 Mar 2013 10:11:43 GMT

Hey Tatiana,

you can use a Straigt Table Chart but for your purpose you've to use "Fecha" and "Origen" as dimensions with "Suppress Zero-Values" disabled in the presentation tab. See attached file.

Regards,

Florian