Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
ankushjain1986
Contributor
Contributor

Count of a column

Hi am new to Qlik and need some help

Need to find the count of a column need a support like how to do the same in Qlik

Below mention is the table for an example

Number Count
*****5814 3
*****5509 1
*****0080 2
*****5814 3
*****5814 3
*****0080 2
*****9863 2
*****9863 2

 

In the number column the number *****5814 appears thrice i want to append this count in Qlik can someone help me on the same

Labels (1)
3 Replies
justISO
Specialist
Specialist

count(Number)

as measure?

ankushjain1986
Contributor
Contributor
Author

Thank for the help @justISO  but it Doesn't work it gives me count as  1 or 0 against the number 

What i exactly want is if 5814 appears 3 times then in count 3 should appear in all the entries wherever 5814 is mentioned. 

justISO
Specialist
Specialist

Hard to say where problem can be here, probably, that your 'Number' isn't just a Number or aggregated dimension. Because, count(Number) should provide number, how many times (in how many rows) this number appears, so it could not be 0 as Number already exist. For better understanding, sample data or exact fields and how you get them is needed.