topic Re: Count in QlikView

Count

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Count

ajsjoshua — Wed, 22 Jun 2016 05:22:50 GMT

Hi,

Count Rows with specific Field-Value

Re: Count

Digvijay_Singh — Wed, 22 Jun 2016 05:23:23 GMT

You may count no of values in a field as -

=FieldValueCount('Division')

Re: Count

qlikview979 — Wed, 22 Jun 2016 05:23:48 GMT

Hi Experts,

Is it possible in Qlikview.

Re: Count

Digvijay_Singh — Wed, 22 Jun 2016 05:27:15 GMT

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

Re: Count

qlikview979 — Wed, 22 Jun 2016 05:30:26 GMT

Hi Digvijay,

I want specific field ''Rows count".

Re: Count

Digvijay_Singh — Wed, 22 Jun 2016 05:43:55 GMT

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

Re: Count

qlikview979 — Wed, 22 Jun 2016 05:54:04 GMT

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.

Re: Count

Frank_Hartmann — Wed, 22 Jun 2016 05:54:55 GMT

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

Re: Count

Digvijay_Singh — Wed, 22 Jun 2016 05:58:56 GMT

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

Re: Count

qlikview979 — Wed, 22 Jun 2016 06:05:24 GMT

Hi Experts,

Thanks for your Support

Regards,

Mahesh

Re: Count

Kushal_Chawda — Wed, 22 Jun 2016 06:08:14 GMT

You may want this

QlikView App - Generic Data Profiler

Re: Count

qlikview979 — Wed, 22 Jun 2016 06:36:56 GMT

Hi Bro,

Thanks After a long time you given reply to me.

How can i get Qlikview designed sample Dashboards ?

Regards,

Mahesh

Re: Count

Kushal_Chawda — Wed, 22 Jun 2016 08:13:05 GMT

see this

QlikView Templates

Re: Count

qlikview979 — Wed, 22 Jun 2016 08:26:30 GMT

Hi ,

Thanks Bro

Regards