topic Re: getting noofrows against a field in QlikView

getting noofrows against a field

Anonymous — Mon, 11 Sep 2017 12:04:34 GMT

suppose i have a fielda

which has values

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 — Mon, 11 Sep 2017 12:11:53 GMT

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 — Mon, 11 Sep 2017 12:13:48 GMT

How 2 getting 645657??

effinty2112 — Mon, 11 Sep 2017 12:20:46 GMT

Hi,

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

Cheers

Andrew

Anonymous — Mon, 11 Sep 2017 12:29:21 GMT

number of records of the whole table against field a

Peter_Cammaert — Mon, 11 Sep 2017 12:33:07 GMT

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 — Mon, 11 Sep 2017 12:39:45 GMT

Hi Dy,

Please mark the right or helpful answers as appropriate.

Many Thanks

Karthik