topic Cannot see all data in Dimension in QlikView

Cannot see all data in Dimension

Wed, 05 Jan 2011 11:51:36 GMT

Hi all,

just a quick question. I just started with QLik-View (Personal Edition) to evaluate the software for our company. Now I test-loaded
some data from databases, which did run very well after playing around a bit with the script and the SQL-Connection.

Now, my problem is as follows: I have loaded a small data-set from 07/2007 to 01/2011, created a LineChart out of it. It consists
my Date as the Dimension and two values as a expression, a max and a average value. Now, even if I select all mentioned dates
the Graph does not display all the values, making it not possible to follow the values from ´07 to ´11.

Would be very nice if some of you can lead me in the right direction on how I make all the values show up.

Best regards!

Cannot see all data in Dimension

Wed, 05 Jan 2011 12:35:53 GMT

can you plz send you apllication ........... so that we can see where the problem is ?????/

Cannot see all data in Dimension

Wed, 05 Jan 2011 13:15:27 GMT

Thank you for your fast reply! I will try to be more detailed with this:

Like I said I loaded data from 2007 to 2011. Now, even if I select them all (all dates)
only the time from 08/2007 to 02/2008 is displayed.

About to send the application, how? As I then maybe have to remove or obfuscate the
data.

Best regards

Cannot see all data in Dimension

Fri, 07 Jan 2011 12:18:00 GMT

Trying showing all distinct values.

Sometimes QV doesn't show multiple entries of the same value.,

also you may have no values for certain dates thus they wont be shown, you can force them to show by unticking hide null.

QV can only display values were they exist it wont force a dimension.

Cannot see all data in Dimension

johnw — Sat, 08 Jan 2011 01:54:32 GMT

In case it is relevant, the attached file shows how to include dates that aren't actually in your data set, allowing a line graph, say, to go to zero for those dates.