Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sayyam005
New Contributor

Totals function - Auto and Sum

When i use 'Auto' in total fuctions the total value i get is 5.35% but when i choose 'Sum' in Total functions i get 3.24%.

The individual values are same for both Value 0 and Value 1 as formula i am using here is

($(='(1+Sum({<B=Comp,DateField={"' & GetFieldSelections(DateField,'"}>} Sales*0.01)) * (1+Sum({<B=Comp, DateField={"') & '"}>} Sales*0.01))')-1)/100


My question :

i want to get total value using expression, so i put total just before sales in the formula


($(='(1+Sum({<B=Comp,DateField={"' & GetFieldSelections(DateField,'"}>} total Sales*0.01)) * (1+Sum({<B=Comp, DateField={"') & '"}>} total Sales*0.01))')-1)/100


and it gives me 5.35


How do i get 3.24 instead of 5.35 using expression ?

15 Replies
pradosh_thakur
Valued Contributor III

Re: Totals function - Auto and Sum

This will shed some light perhaps.

https://community.qlik.com/thread/250400

regards

Pradosh

sayyam005
New Contributor

Re: Totals function - Auto and Sum

thanks for replying pradosh ,but that tells me the difference between auto and sum

my question is how do i achieve that sum total using expression because i need to use that total at some other place

MVP
MVP

Re: Totals function - Auto and Sum

May be this

Sum(Aggr(

($(='(1+Sum({<B=Comp,DateField={"' & GetFieldSelections(DateField,'"}>} Sales*0.01)) * (1+Sum({<B=Comp, DateField={"') & '"}>} Sales*0.01))')-1)/100

, YourDimensionsHere))

pradosh_thakur
Valued Contributor III

Re: Totals function - Auto and Sum

what about


expression:


sum(($(='(1+Sum({<B=Comp,DateField={"' & GetFieldSelections(DateField,'"}>} total Sales*0.01)) * (1+Sum({<B=Comp, DateField={"') & '"}>} total Sales*0.01))')-1)/100)

sayyam005
New Contributor

Re: Totals function - Auto and Sum

Sorry,already tried this but it doesn't work because that formula you enclosed within sum gives a single value 5.35

pradosh_thakur
Valued Contributor III

Re: Totals function - Auto and Sum

you tried sunny's expression? That shall work.

regards

Pradosh

sayyam005
New Contributor

Re: Totals function - Auto and Sum

with that i get  0.00%

MVP
MVP

Re: Totals function - Auto and Sum

Did you specify your dimensions in there?

MVP
MVP

Re: Totals function - Auto and Sum

Besides did you try the alternative approach to calculating what you intended?

=Exp(Sum(Aggr(Log(1+Sum(Sales)), TimeKey))) - 1