Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

field level count values

NAMES
1.NAVEEN
2.RAJU
1.NAVEEN
2.RAJU
3.JOHN

2.RAJU

Tags (1)
4 Replies
sureshqv
Esteemed Contributor III

Re: field level count values

Hi,

use

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

or

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

Re: field level count values

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

if you want total value count then use

Count(total FieldName)

Not applicable

Re: field level count values

Result is ok

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

sureshqv
Esteemed Contributor III

Re: field level count values

cool.

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

Qlik Community Tip: Marking Replies as Correct or Helpful