topic field level count values in QlikView

field level count values

Mon, 26 Jan 2026 18:19:17 GMT

NAMES

1.NAVEEN

2.RAJU

1.NAVEEN

2.RAJU

3.JOHN

2.RAJU

Chanty4u — Sat, 26 Mar 2016 06:16:58 GMT

Hi,

use

=count(urfield) // it will gives u total count

count(Distinct Filedname) // it will gives u distnct count

Kushal_Chawda — Sat, 26 Mar 2016 06:22:04 GMT

=FIeldValueCount('FieldName') - this will always give you distinct value count

if you want total value count then use

Count(total FieldName)

Mon, 28 Mar 2016 19:50:35 GMT

Result is ok

count({<NAMES={'1.NAVEEN'}>}NAMES)

Chanty4u — Thu, 31 Mar 2016 06:40:06 GMT

cool.

if u got the solution please close this thread as correct and helpful answers