don't want distinct

[Anonymous]

Hi All,

Below is my data when iam doing sum(col1) it is missing last record (28800), how to count All values

these values are cumming from QVD

Col1	Col2
Assignee	252000
Assignee	144000
Assignee	115200
Assignee	57600
Assignee	28800
Assignee	28800

It show's in qlikview  as below  , need same as above

Col1	Col2
Assignee	252000
Assignee	144000
Assignee	115200
Assignee	57600
Assignee	28800
Assignee	-

Regards,

Nagesh

[prat1507]

Hi

You may have a problem with data load. Please check. I'm getting the desired results. PFA.

Regards

Pratyush

[eromiyasimon]

how can you sum col1 which is containing text value

attach sample QVW

[vinieme12]

can you post the app that demonstrates the problem? are you doing this with an inline table load?

[rahulpawarb]

Hello Nagesh,

You can apply Count function on Col1 as well as Col2; however, Sum function can only be applied on Numeric values.

As per my primary analysis, last record (28800) is not missing; it is there in application. 2nd last and last record have same values; due to this QlikView is interpreting it as single combination.

If you create the straight table with Col1 & Col2 as dimensions and Count(Col1) & Sum(Col2) then you will notice that last record is there. Refer attached sample application.

Also, to get distinct values you can make use of RowNo() or RecNo() function (refer below given sample script).

Data:
LOAD *,
RowNo() AS RowNo,
RecNo() AS RecNo;
LOAD * INLINE [
Col1, Col2
Assignee, 252000
Assignee, 144000
Assignee, 115200
Assignee, 57600
Assignee, 28800
Assignee, 28800
];

Regards!

Rahul

[sdmech81]

HI,

R u doing sum(col2)..It should give u desired result..

Plss attach sample qvw..

Sachin

[#7]

Hi Nagesh,

please share your sample application so that we will help to you.

[#8]

try like this

count(nodistinct col1)