topic Re: Dollar Sign Expansion, Problem with arithmetic on the result in QlikView

Dollar Sign Expansion, Problem with arithmetic on the result

effinty2112 — Sun, 03 Jul 2016 15:32:42 GMT

Hello,

I have variable with a parameter: eSQMTotalforYear($1) with formula :

Sum({$<$(=eYear) = {$(=-$1+max($(=eYear)))}>} Qty*[Chargeable Unit SQM])

I get the answer I want. A textbox containing: =$(eSQMTotalforYear(0)) returns 871541.71999991 which is correct.

The problem I have is that I can't perform any arithmetic on the result.

I wanted the difference between this year and last but a textbox containing: =$(eSQMTotalforYear(0)) - $(eSQMTotalforYear(1)) disregards

the second half of the expression and I get 871541.71999991 again.

$(eSQMTotalforYear(1)) on its own gives the correct figure for the previous year :1677744.7799994

Even subtracting a constant has no effect : =$(eSQMTotalforYear(0)) -800000 returns : 871541.71999991.

I'm hoping there's something obvious I've overlooked.

Kind regards

Andrew Walker

Re: Dollar Sign Expansion, Problem with arithmetic on the result

marcus_sommer — Sun, 03 Jul 2016 16:04:35 GMT

Could this: Well-commented variables. Be careful! be the reason?

- Marcus

Re: Dollar Sign Expansion, Problem with arithmetic on the result

effinty2112 — Sun, 03 Jul 2016 16:51:25 GMT

Thanks Marcus,

I had a commented out previous version of my expression after my working expression and that was throwing the spanner into the works.

Cheers

Andrew

Re: Dollar Sign Expansion, Problem with arithmetic on the result

trdandamudi — Sun, 03 Jul 2016 17:05:12 GMT

This is very interesting,,,, Can you please share a small sample so that we can take a look and see what is happening..

Re: Dollar Sign Expansion, Problem with arithmetic on the result

effinty2112 — Sun, 03 Jul 2016 19:09:49 GMT

Hi Thirumala,

Marcus pointed me in the right direction. My first expression's formula ended in a comment and when this was expanded the // commented out everything that followed including the second expression.

Cheers

Andrew