topic Re: Wrong Count in Straight Table in QlikView

Wrong Count in Straight Table

Thu, 18 Jul 2013 17:48:50 GMT

Hi all,

my problem is a little bit hard to explain, but I'll try my best:

I'm retrieving data from different sharepointlists i.e. called prod issues, dev requests and team tracker. All these lists include different kind of dates and persons (example for prod issue: pic 1). They have similar columns but not identical ones. All they have in common is the requestor.

So far I was able to connect them with different loads using a flag. So if I click on production issues, I can see which kind of dates and persons are available.

My next step was to count the id, to see how many reports were opened/closed etc (depending on kind of date) at a certain month.

Here is my problem! It works fine with one exception: the "-" under column email (pic2). I really dont know where this comes from. It couldn't be a blank because they are counted in an extra row (count is correct). All the other counts are also correct except for the "-" which appears for each column. The only thing that adulterates my count. Therefore my line chart is also wrong...

Attached is also a part of my script code which should illustrate you my procedure.

I also tried resident load, load distinct... never the right solution.

Maybe its just an expression I have to add at the line chart and straight table...

Happy about any help! Thanks!

Re: Wrong Count in Straight Table

Gysbert_Wassenaar — Thu, 18 Jul 2013 19:01:47 GMT

The "-" means a null value. Those records don't have a value in the email field. The 'real' blanks are empty strings (or possible strings of x spaces). Those are not null values. The null values are probably created by combining the data with other tables. Your code example.txt doesn't show where TT_ID and DR_ID are coming from. Can you post an example document? You can scramble the data to ensure confidentiality:

Preparing examples for Upload - Reduction and Data Scrambling.

Re: Wrong Count in Straight Table

Thu, 18 Jul 2013 19:29:56 GMT

Thanks for your attention and also the scramble functionality! Attached my qvw file.

Re: Wrong Count in Straight Table

Gysbert_Wassenaar — Fri, 19 Jul 2013 07:06:43 GMT

Whoa, that's not a very pretty data model. You've got a massive syntethic key table. That needs fixing. First try concatenating all the xml/data/row-xx tables into one table.

Re: Wrong Count in Straight Table

Fri, 19 Jul 2013 07:54:18 GMT

Hi,

Hope it is helpful.

Re: Wrong Count in Straight Table

Mon, 22 Jul 2013 14:46:19 GMT

Somestimes it is so easy! This was the thing which fixed it. Thank you so much.