topic Re: Problem with SUM in QlikView

Problem with SUM

stark___ — Mon, 14 Apr 2014 12:50:45 GMT

Hello.

Can you help me to write this expression "sum({$<Scenario={'Control budget '&Year&' (by the quarter)'}>} Sales)", correctly?

The main term is when I select the Year (for example: 2014), it inserted in the expression and Scenario should get 'Control budget 2014 (by the quarter)' and expression return total "Control budget 2014 (by the quarter)" sales, when I select "2013" it return total "Control budget 2013 (by the quarter)" sales.

Thanks for your help, Stark

Re: Problem with SUM

alexandros17 — Mon, 14 Apr 2014 12:54:35 GMT

Try This

sum({$<Scenario={'$("Control budget" & GetFieldSelections(Year) & " (by the quarter))"}

Re: Re: Problem with SUM

stark___ — Tue, 15 Apr 2014 11:31:59 GMT

Hi, Alessandro.

I try to use your advise, but unfortunately it doesn't work.

Can you see my attached sample, maybe I do something wrong?

Best regards, Stark

Re: Problem with SUM

tresB — Tue, 15 Apr 2014 11:40:03 GMT

Define a variable and use that in the expression, like:

Variable1='Control budget '&GetFieldSelections(Year)&' (by the quarter)'

Expression:

sum({$<Scenario={'$(Variable1)'}>}Sales)

Re: Problem with SUM

arjunkrishnan — Tue, 15 Apr 2014 11:40:11 GMT

Hai Frd Try This One

GetFieldSelections(Scenario)&chr(10)&sum(Sales)

Result Like That

Re: Problem with SUM

jonathandienst — Tue, 15 Apr 2014 11:42:13 GMT

This will work as long as there is a single selected or possible value of Year:

=sum({$<Scenario={"$(='Control budget ' &Year & ' (by the quarter)')"}>} Sales)

HTH

Jonathan

Re: Re: Problem with SUM

stark___ — Tue, 15 Apr 2014 12:04:43 GMT

Thank you, Tresesco.

This is exactly what I need.

Best regards, Stark.

Re: Re: Problem with SUM

stark___ — Tue, 15 Apr 2014 12:08:28 GMT

Thank you, Jonathan.

Your expression works perfect.

Best regards, Stark.