topic repeated data not getting count in QlikView

repeated data not getting count

sagarrahul — Wed, 11 May 2016 12:58:04 GMT

hii i am having problem in this

below is a column of my table

in this total count is 19 but i am getting only 15 count of it

in this repeated data is not getting counted

so please help me in this

and give me a code as soon as possible

CODE

M51.9

M54.5

S62.3

S92.7

S72.9

S02.2

S42.4

S72.4

S42.0

S42.4

S52.9

S42.4

S82.2

S82.7

S92.3

Re: repeated data not getting count

MK_QSL — Wed, 11 May 2016 12:59:08 GMT

Add below while loading in script.

RowNo() as ID

Re: repeated data not getting count

sunny_talwar — Wed, 11 May 2016 12:59:36 GMT

Are you doing a distinct count or Count? I think a simple count should get you 19

Count(CODE)

Re: repeated data not getting count

PrashantSangle — Wed, 11 May 2016 13:02:01 GMT

Hi,

Simple count(Code) must work.

kind Regards,

Re: repeated data not getting count

trdandamudi — Wed, 11 May 2016 13:02:18 GMT

May be this:

Source_Data:

Load * Inline [

CODE

M51.9

M54.5

S62.3

S92.7

S72.9

S02.2

S42.4

S72.4

S42.0

S42.4

S52.9

S42.4

S82.2

S82.7

S92.3

];

NoConcatenate

Final:

Load

RowNo() as RowNumber,

CODE

Resident Source_Data;

Drop Table Source_Data;

Re: repeated data not getting count

sagarrahul — Thu, 12 May 2016 03:52:08 GMT

its not working

i am using just count(code) still its not coming

Re: repeated data not getting count

sagarrahul — Thu, 12 May 2016 03:53:13 GMT

i do not want to load this filed can you suggest other options

Re: repeated data not getting count

settu_periasamy — Thu, 12 May 2016 04:24:38 GMT

Hi sagar,

The count(CODE) is working. check the attachment..

Re: repeated data not getting count

ajsjoshua — Thu, 12 May 2016 05:22:53 GMT

Hi,

If normal count is not working try counting with aggr

=sum(aggr(count(code),id))

PFA

Regards,

Joshua.