Two set analysis expressions in one expression

Mon, 31 Oct 2016 17:24:56 GMT

Hi,

I am trying to implement the below logic into an expression in a pivot table. For one subset of my data I'd like to sum the "Current Balance" field for a different "Production Date" than the other set. The problem is that they do not sum together in the end. Is there anything that I can add to the logic that would allow these to add together in the pivot table?Is an if statement the way to go for this or is there a better way?

if([Toggle]= 'Yes'

, sum({$<[Production Date]={"=2016-04-29"}>} [Current Balance]/1000)

, sum({$<[Production Date]={"$(=date(max({1<Year={$(=max(Year)-1)}>} [Production Date])))"}>} [Current Balance] /1000), )

Thank you.

topic Two set analysis expressions in one expression in QlikView

Two set analysis expressions in one expression