Count number of times a field appears in a table

[jalanhart]

I am trying to create a field in a table where each row shows the total number of times a record appears in a table.

every count formula i can think of and try is giving me a value of 1 and not it's total. 

I can do this in EXCEL by saying countif(A:A, Criteria). How do i do that in QLIK?

[jochem_zw]

Something like:

Count(Total <FRUIT> FRUIT)

[jalanhart]

that did not work. there are obviously more columns that this. I've attached an example but they keep showing up as 1 each time. as where I'd like each row to say its total which is 48 in this example. 

I tried count (total <ROLE> ROLE)

[fabdulazeez]

You might need to use count(site) to get the distinct count across the rows.

[Qrishna]

1. if you want this  view

Dim: FRUIT, Measure: Count(Total <FRUIT> FRUIT)

2.if you want this view:

// Backend Solution:
Data:
Load RecNo() as S.no,*;
LOAD FRUIT
FROM
[F:\Qlik\Qlik View\Comm_Qlik Solutions\2491217 - Total Count for all Values\2491217 - Total Count for all Values.xlsx]
(ooxml, embedded labels, table is Sheet2);

left join(Data)
load FRUIT, count(FRUIT) as Nett
resident Data
group by FRUIT;

//Fron End Solution:
Dim: S.no, Fruit --> Hide S.no
Measure: Count(Total <FRUIT> FRUIT)