Total Function in Alternate State

[qlikwiz123]

Hi,

How do I add Alternate State parameters in an expression with total?

sum(sales)/ sum(total < Month, Group > sales )

My Alternate State is State1 and here are the filters that I have in the state

Name=State1::Name,Country=State1::Country

How do I include these in the given expression?

[Digvijay_Singh]

May be this -

sum({<Name= State1::Name, Country = State1::Country>}sales)/ sum({<Name= State1::Name, Country = State1::Country>}total < Month, Group > sales )

[qlikwiz123]

Hi,

Thanks. That was from my Sample data set. There is a much more complex expression and I was wondering if you could help me with that.