Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator II
Creator 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

May be this -


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


qlikwiz123
Creator II
Creator II
Author

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.