topic Re: Data not displayed in straight table in QlikView

Data not displayed in straight table

Wed, 29 Aug 2012 14:45:19 GMT

I have data being selected for my straight table by using a
very specific where statement in one of my loads, in my script. It should be showing me 2 rows of data, but
as you can see by the screen shot, it is not.

A COGNOS report shows these rows as does a straight SQL
query on the database. When I reload my
script, it displays the message that 2 lines were fetched.

To check my sanity, I added a Text Object that displays the
following expression:

=count(RIInventory_extended_cost)

This is one of the fields (RIInventory_extended_cost)
in my table and again, as you can see by the screen print it (blue box)
displays 2.

So I know that data exists
in my source. I know it is in my QV
loads. Is there something that stops the
display of data based on a setting or anomaly that I have not encountered
before?

(I have only been working
with Qlikview for about 3 months so I am a beginner at best)

Re: Data not displayed in straight table

Anonymous — Thu, 30 Aug 2012 13:53:46 GMT

Hi, I would say: check the dimension(s) you have set up in this table. Regards, Sander

Re: Data not displayed in straight table

chematos — Fri, 31 Aug 2012 19:58:21 GMT

In the straight table, do you have any expression or all the columns are dimensions? You need to add any expression to get data in the rows

Re: Data not displayed in straight table

Tue, 04 Sep 2012 13:42:42 GMT

Yes - there are a few fields set up as expressions.

As an additional bit of information: if I 'loosen' up the script, so that more rows are selected, data then appears - but still not the 2 rows that are not showing here.

Re: Data not displayed in straight table

chematos — Tue, 04 Sep 2012 13:53:07 GMT

Could you upload the file? Is hard to say what´s happening with only this information, sorry