Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sagarrahul
New Contributor III

repeated data not getting count

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

S92.7

S72.9

S02.2

S02.2

S42.4

S72.4

S42.0

S42.4

S42.4

S52.9

S42.4

S42.4

S82.2

S82.7

S92.3

8 Replies
MVP
MVP

Re: repeated data not getting count

Add below while loading in script.

RowNo() as ID

Re: repeated data not getting count

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

Hi,

Simple count(Code) must work.

kind Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
trdandamudi
Honored Contributor

Re: repeated data not getting count

May be this:

Source_Data:

Load * Inline [

CODE

M51.9

M54.5

S62.3

S92.7

S92.7

S72.9

S02.2

S02.2

S42.4

S72.4

S42.0

S42.4

S42.4

S52.9

S42.4

S42.4

S82.2

S82.7

S92.3

];

NoConcatenate

Final:

Load

RowNo() as RowNumber,

CODE

Resident Source_Data;

Drop Table Source_Data;

sagarrahul
New Contributor III

Re: repeated data not getting count

its not working

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

sagarrahul
New Contributor III

Re: repeated data not getting count

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

Re: repeated data not getting count

Hi sagar,

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

ajsjoshua
Contributor III

Re: repeated data not getting count

Hi,

If normal count is not working try counting with aggr

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

PFA

Regards,

Joshua.

Community Browser