Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
qlikwiz123
Contributor II

Total Function in Alternate State

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?

2 Replies
Digvijay_Singh
Honored Contributor III

Re: Total Function in Alternate State

May be this -


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


qlikwiz123
Contributor II

Re: Total Function in Alternate State

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.