topic Re: Total by dimenssion in QlikView

Total by dimenssion

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

hey all,

i have a bar chart that has a dimenssion a. Cyclic group inside it year month day and a second dimenssion (type:local

international)

need to calculate each Time i change the dimenssion calculate the % as :

if the dimension is year >>>> sum(amount)/sum(TOTAL<year>amount)

if dimension is month >>>> sum(amount)/sum(TOTAl<month>amount)

if dimenssion is day>>>>sum(amount)/sum(TOTAL<day>amount)

hope you can help

‌

Re: Total by dimenssion

sunny_talwar — Tue, 08 Mar 2016 10:15:36 GMT

May be try this:

Sum(amount)/Sum(TOTAL <$(=GetCurrentField('CycleGroupName'))> amount)

Re: Total by dimenssion

Anonymous — Tue, 08 Mar 2016 10:17:00 GMT

sum(total {<give the dimension>}amount)

Re: Total by dimenssion

tresB — Tue, 08 Mar 2016 10:36:36 GMT

With a brace and quotes correction:

Sum(amount)/Sum(TOTAL <$(=GetCurrentField("CyclicGroupName"))> amount)

Re: Total by dimenssion

avinashelite — Tue, 08 Mar 2016 10:39:36 GMT

Try like this

store your cyclic dimension selection in a variable

vselection = GetCurrentField('CycleGroupName')

then try like this in the expression

Sum(TOTAL <$(vselection )> amount)

Re: Total by dimenssion

sunny_talwar — Tue, 08 Mar 2016 10:45:28 GMT

I still feel that single quotes should work tresesco‌. Thanks for pointing out the parenthesis issue

Re: Total by dimenssion

tresB — Tue, 08 Mar 2016 10:53:26 GMT

Have you tried? With me it doesn't work.

Re: Total by dimenssion

sunny_talwar — Tue, 08 Mar 2016 10:55:44 GMT

Right now, I haven't, but I have feeling that it did work in the past. But I guess you have tested it more recently, then you must be right. Memories are sometimes deceiving .

Re: Total by dimenssion

sunny_talwar — Tue, 08 Mar 2016 14:44:20 GMT

tresesco‌ you were right. Single quotes doesn't work. We either need double quotes or square brackets. In addition if we have spaces between the field name we might need to add square brackets within the dollar sign expansion:

=Sum(Amount)/Sum(TOTAL <$(='[' & GetCurrentField([Cycle Group]) & ']')> Amount)

Attached application, I tried to test it out.

Re: Total by dimenssion

Anonymous — Mon, 21 Mar 2016 12:36:37 GMT

sum(sales)/sum(total{<cyclic group name>} sales)

try this one