Noob needs help

Thu, 24 May 2012 19:18:31 GMT

Hi, 3rd day using QV..

Wanted to practice drill down, so created Excel sheet with Quarters, Months, and Weeks (1-4, Jan-Feb, 1-52) and some income and expense figures:

In my Excel sheet, July looks like this:

3	July	26	0	0	0
3	Juy	27	1200	300	500
3	July	28	0	0	0
3	July	29	1200	300	500
3	July	30	0	0	0

However, when I loaded the table and tried to create chart, two "July" entries show up. One bar is week 26 AND weeks 28,29,30. The other bar is only week 27. If I go to the tables in the QV sheet, and click on July in the Month table, it highlights 26, 28, 29, 30 in the week table, but not 27. On the other hand, when I click on week 27 in the Weeks table, it highlights July in the Month table. I've reloaded several times, re-entered and saved the data in Excel, but the same thing keeps happening. Any ideas?

Noob needs help

Thu, 24 May 2012 19:53:07 GMT

How many times did I stare at this before seeing that "July" was spelled "Juy" in wk 27? Duhhhhh...

topic Noob needs help in QlikView

Noob needs help

Noob needs help