Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarrahul
Creator
Creator

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
MK_QSL
MVP
MVP

Add below while loading in script.

RowNo() as ID

sunny_talwar

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

Count(CODE)

PrashantSangle

Hi,

Simple count(Code) must work.

kind Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
trdandamudi
Master II
Master II

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
Creator
Creator
Author

its not working

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

sagarrahul
Creator
Creator
Author

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

settu_periasamy
Master III
Master III

Hi sagar,

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

ajsjoshua
Specialist
Specialist

Hi,

If normal count is not working try counting with aggr

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

PFA

Regards,

Joshua.