Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to replicate the count column( the fourth column) of excel to a Qlik plain table chart by using expression
I assume aggr and count would be used ...tried a few variations, no luck
so each sku has different product type, if it has 4 , the count column should show distinct count of 4, if it has 3, then it returns 3.
SKU | Product type | CONT_TYPE | COUNTIFS($A$2:$A$996,A2) |
6403 | A | Regular | 4 |
4401 | D | Regular | 3 |
6403 | D | Regular | 4 |
4401 | C | Regular | 3 |
4401 | B | Regular | 3 |
6403 | B | Regular | 4 |
6403 | C | Regular | 4 |
Count(Distinct Total <SKU> [Product type]) perhaps?
As below.
=Count(TOTAL <SKU> SKU)