Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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.