topic Re: Combine 2 Formulas in QlikView

Combine 2 Formulas

Fri, 29 Aug 2014 15:07:14 GMT

Hello together,

i have to formuals

sum({$<Nature={Actual}>}€)

and

Sum({<[year]={$(vYTDYear)} >}[€]))

vYTDYear = (max(year))

My Suggestion is

sum({$<Nature={Actual}>} <[year]={vYTDYear)}>}

Can you help me.

Thanks

phaneendra_kunc — Fri, 29 Aug 2014 15:12:59 GMT

Use this

sum({$<Nature={'Actual'} ,[year]={$(vYTDYear)}>}[€])

Fri, 29 Aug 2014 15:42:26 GMT

Hi,

try this:

Sum({$<Nature={'Actual'},year={$(#=vYTDYear)}>} [€])

$(#=) means QV has to read your variable as a Number.

Best regards

mrooney — Fri, 29 Aug 2014 21:50:46 GMT

I think you are right. This expression should be enough.

Mon, 01 Sep 2014 09:26:20 GMT

Hello,

it Shows me the follow sign '-' in the table.

Do you know, why?

Mon, 01 Sep 2014 09:28:48 GMT

thank you, but it Shows only the value '0' in the table.

Do you have an other idea?

Thanks.

phaneendra_kunc — Mon, 01 Sep 2014 14:07:34 GMT

Howz your max year variable was setup? Do you have equal sign in front of the expression in variable?

if yes use the expression I have posted above.

it will be easy if for us if you can share your sample QVW.