topic Re: Calculation problem in Counts in QlikView

Calculation problem in Counts

Anonymous — Thu, 09 Feb 2017 06:49:33 GMT

Hi Buddies,

Can u please help me out to calculate the count in straight table

For example:

if i do sum(total field) i'm getting total sum but i'm expecting sum by year wise. please help me out. Thanks in advance.

vinieme12 — Thu, 09 Feb 2017 06:56:41 GMT

Count ( total <FiscalYear> field)

Sum ( total <FiscalYear> field)

Anil_Babu_Samineni — Thu, 09 Feb 2017 07:04:42 GMT

May be this?

sum(aggr(sum(total <FiscalYear> Field),FiscalYear,ServiceType))

Anonymous — Thu, 09 Feb 2017 07:06:07 GMT

Hi Vineeth,

Thanks for reply, but its not working please check attached file

vinieme12 — Thu, 09 Feb 2017 07:07:57 GMT

Use sum (total <FiscalYear> field)

On mobile , can't check the app sry

vinieme12 — Thu, 09 Feb 2017 07:10:13 GMT

What is field here? Is it an existing expression in your straight table??

Then use

Sum (total <FiscalYear> Aggr (sum (Field),FiscalYear))

did you try the above, sivaprakash.t , we only need to Aggr() on the dimension we need the total on.

gowtham_patnaik — Thu, 09 Feb 2017 07:17:54 GMT

try this:

1)Add Fiscal Year as Dimension.

2)Write expression be like:

=Count(num( field))