getting noofrows against a field - Qlik Community

Anonymous · ‎2017-09-11

suppose i have a fielda

which has values

2

3

4

5

6

what i need is output number of records from my table against each value of fielda

2 645657

3 67878

4 68678

5 8785

6 678678

karthikoffi27se · ‎2017-09-11

Hi Dy

Just use Count(YOURFIELD) if you want the overall Count or you can use Count(Distinct YOURFIELD) if you want unique count.

Many Thanks

Karthik

Anil_Babu_Samineni · ‎2017-09-11

How 2 getting 645657??

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

effinty2112 · ‎2017-09-11

Hi,

Try a straight table with dimension fielda and expression Count(fielda).

Cheers

Andrew

Anonymous · ‎2017-09-11

number of records of the whole table against field a

Peter_Cammaert · ‎2017-09-11

An example of what Karthik explained in the first reply:

You can use any field in the Count() expression, as long as it doesn't contain NULL values. Those will be skipped.

karthikoffi27se · ‎2017-09-11

Hi Dy,

Please mark the right or helpful answers as appropriate.

Many Thanks

Karthik