I have taken the count with group by ofa database field . But in QlikView it is showning the count for a null value as last coulmn.
In database i have verified all the rows has the values (I mean none of the row is null for the field). Consider the below example
Table name is test and has columns A,B,C. A has the value as A1,A2,A3. Apart from this table i have 2 more tables (test1,test2) which has the Column A. I want to take count for the first table. I have loaded the data from All three tables and i have not used any joins.
A B C
A1 2 1
A2 1 0
A1 3 3
A3 8 1
A4 9 8
A5 1 1
A4 7 2
So i f i am taking the count of B column group By A it is showing as
A1 5
A2 1
A3 8
A4 16
A5 1
18
Where this 18 is coming from ?. If i am using one table it is not happening, If i am using more than one table without any join conditions it is working fine. If i am using more than one table which has similar column names and this is happenning.
Is it due to multiple tables has the similar column name.Can someone help me on this
Nothing to do with script. It is very simple i am uploading data three tables data and there is more possibilty of synthetic keys. While uploading data from one table there was no issues
My Question is very simple will Synthetic Keys create such problems?????
as Blaze has pointed out it will be very difficult to trouble shoot without looking at how you bring the data in. Sythetic keys will NOT do this, but often are signs that something else is wrong in the script.
Can you dummy up something (use in line tables?) so you are able to post the script? Also you mentioned count, but the numbers seem to say sum.
