topic Re: Total Function in QlikView

Total Function

muniyandi — Thu, 31 Jul 2014 07:57:16 GMT

Hi All,

I need total value for Quarter dimension .

Kindly refer my attachment file

Expected Result: For Qtr Total Value expression only

muniyandi — Thu, 31 Jul 2014 08:12:12 GMT

Hi , Any one have answer.

Thu, 31 Jul 2014 08:17:07 GMT

use

Aggr(NODISTINCT sum(Amount), Qtr)

In your expression,

Edit: You might also want to give the community more than 4 minutes to reply before spamming your question too

maxgro — Thu, 31 Jul 2014 08:19:59 GMT

I think you have to add the quarter dimension

sujeetsingh — Thu, 31 Jul 2014 08:24:32 GMT

See this done for you

sujeetsingh — Thu, 31 Jul 2014 08:26:35 GMT

Munish,

Have a look of the sample i have posted .

You can also implement it through pivot table by using Quarter as dimension.

Yousef_Amarneh — Thu, 31 Jul 2014 08:32:28 GMT

Please see the attached, it matches your needs, if so please don't forget to mark my reply as correct answer

muniyandi — Thu, 31 Jul 2014 08:45:43 GMT

Thanks To All,

Special Thanks for Joe Simmons.

Finally i got answer

Thu, 31 Jul 2014 08:49:19 GMT

no worries, glad to be of help, you'll find the Aggr function useful for a number of things, so I would maybe check out this post

Joe

muniyandi — Thu, 31 Jul 2014 08:51:00 GMT

Thanks Joe.