Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ronaldwang
Creator III
Creator III

alternate state expression

in a trend line, i use alternate state on the period so that no matter what period user selects, i can still show the trend line. but at the same time i also want to apply filters from inherit state so i have to use expression like sum{State1<Country = $::Country Product = $::Product>}amount, but when the filters in inherit state is long, the expression will be too long and easy to miss some . is there an easy way so that i can specify for period only apply the filter from inherit state but at the same time also apply all filters from inherit state, hope my above is making sense.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Turn the logic around. Use the inherited state for every field except the Period field:

sum({<Period= State1::Period>}amount)


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Turn the logic around. Use the inherited state for every field except the Period field:

sum({<Period= State1::Period>}amount)


talk is cheap, supply exceeds demand