topic Re: Counting rows in a straight table in QlikView

Counting rows in a straight table

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

Dear community,

I would like to count the data entries in straight tables that are generated by various expressions.

I am currently using two dimensions in the straight tables, company and account name.

Just counting the companies that show up in the table (9 in this case) would be enough, if I can count every single row (18) that's fine as well.

Thank you in advance!

I will attach the sample.

Best regards,

Mats

Re: Counting rows in a straight table

Anil_Babu_Samineni — Thu, 08 Jun 2017 10:59:51 GMT

Can you try this, May be?

Count(Aggr(IF([FS Item] >= 100000 and [FS Item]<= 2000000 and Sum([Period Value GC]) <= 0, Sum ([Period Value GC])) ,[Name Financial Statement Item]))

Re: Counting rows in a straight table

vinieme12 — Thu, 08 Jun 2017 11:01:13 GMT

For Total Rows

=sum(AGGR(if(sum({<[FS Item]={">=100000<=2000000"} >} [Period Value GC])<0,1),[Company Name],[Name Financial Statement Item]))

For Distinct count of Companies

=count(distinct AGGR(if(sum({<[FS Item]={">=100000<=2000000"} >} [Period Value GC])<0,[Company Name]),[Company Name],[Name Financial Statement Item]))

Check the attached

Re: Counting rows in a straight table

sunny_talwar — Thu, 08 Jun 2017 11:03:40 GMT

May be this

Count(DISTINCT Aggr(IF([FS Item] >= 100000 and [FS Item]<= 2000000 and Sum([Period Value GC]) < 0, [Company Name]), [Company Name], [Name Financial Statement Item]))

or this

Count(DISTINCT Aggr(IF([FS Item] >= 100000 and [FS Item]<= 2000000 and Sum([Period Value GC]) < 0, [Name Financial Statement Item]&[Company Name]), [Company Name], [Name Financial Statement Item]))

Re: Counting rows in a straight table

Anonymous — Thu, 08 Jun 2017 11:25:08 GMT

Works as well! Thanks.

Re: Counting rows in a straight table

Anonymous — Thu, 08 Jun 2017 11:25:20 GMT

Works like a charm, thanks!

Re: Counting rows in a straight table

Anonymous — Thu, 08 Jun 2017 11:26:29 GMT

works, thank you