Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
count(Number)
as measure?
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.
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.