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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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.

Labels (1)
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