Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Straight Table is not displaying info correctly

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.

T

4 Replies
jsn
Not applicable

Re: Straight Table is not displaying info correctly

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?

Not applicable

Re: Straight Table is not displaying info correctly

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

Not applicable

Re: Straight Table is not displaying info correctly

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.

Capture.JPG

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

pennetzdorfer
Not applicable

Re: Straight Table is not displaying info correctly

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

1.jpg