Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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