topic Re: Total Function in Alternate State in QlikView

Total Function in Alternate State

qlikwiz123 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 02 Mar 2018 16:37:11 GMT

May be this -

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

qlikwiz123 — Fri, 02 Mar 2018 16:52:10 GMT

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.