Total Function

[muniyandi]

Hi All,

I need total value for Quarter  dimension .

Kindly refer my attachment file

Expected Result: For Qtr Total Value expression only

Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Month Value	100	400	200	300	200	500	302	408	200	700	500	400
Year Value	4210	4210	4210	4210	4210	4210	4210	4210	4210	4210	4210	4210
Qtr Total Value	700	700	700	1000	1000	1000	910	910	910	1600	1600	1600

[muniyandi]

Hi , Any one have answer.

[#3 · Accepted solution]

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]

I think you have to add the quarter dimension

[sujeetsingh]

See this done for you

[sujeetsingh]

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]

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

[muniyandi]

Thanks To All,

Special Thanks for Joe Simmons.

Finally i got answer

sum(Aggr(nodistinct sum(TOTAL <Qtr> Amount),Qtr))

[#9]

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

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/07/aggr

Joe

[muniyandi]

Thanks Joe.