Count

[qlikview979]

Hi Experts,

If i use Noofrows('TN')  i will get how many rows in table. that is fine.

But Here my doubt is How can i get Noofrows In one Field in front end.

Regards,

Mahesh.

[ajsjoshua]

Hi,

Count Rows with specific Field-Value

[Digvijay_Singh]

You may count no of values in a field as -

=FieldValueCount('Division')

[qlikview979]

Hi  Experts,

Is it possible in Qlikview.

[Digvijay_Singh]

Couldn't understand, can you elaborate in case you fieldvaluecount doesn't serve the purpose.

[qlikview979]

Hi Digvijay,

I want specific field ''Rows count".

[Digvijay_Singh]

You mean specific field value like 'Product1' in Product Dimension in a list box. You can use Frequency option in list box -

I still feel confused from 'row count' as don't know what does that mean in Front end

[qlikview979]

Hi Digvijay,

For Example:-  My Field name "peoduct". in this field i don't know how many records.

My condition is :-  if(product<=20000,1,0)

here product(specific) field count i need.

Regards,

Mahesh.

[Frank_Hartmann]

what about creating straight table and adding expression like: Rowno()?

[Digvijay_Singh · Accepted solution]

You should use

if(fieldvaluecount('product')<=20000,1,0)

if I rightly understand

With reference to field we use 'Values', with reference to table we use 'record' terminology, so getting confused from beginning