topic alternate state expression in QlikView https://community.qlik.com/t5/QlikView/alternate-state-expression/m-p/1435299#M798242 <HTML><HEAD></HEAD><BODY><P>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<SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">{State1&lt;Country = $::Country Product = $::Product&gt;}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.</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ronaldwang 2020-11-25T16:16:04Z alternate state expression https://community.qlik.com/t5/QlikView/alternate-state-expression/m-p/1435299#M798242 <HTML><HEAD></HEAD><BODY><P>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<SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;">{State1&lt;Country = $::Country Product = $::Product&gt;}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.</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/alternate-state-expression/m-p/1435299#M798242 ronaldwang 2020-11-25T16:16:04Z Re: alternate state expression https://community.qlik.com/t5/QlikView/alternate-state-expression/m-p/1435300#M798243 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Turn the logic around. Use the inherited state for every field except the Period field: </SPAN></P><P><SPAN style="font-size: 14px; font-family: 'Open Sans', Arial, sans-serif; color: #0f0f0f;">sum({&lt;Period= State1::Period&gt;}amount)</SPAN></P></BODY></HTML> Wed, 06 Dec 2017 08:11:24 GMT https://community.qlik.com/t5/QlikView/alternate-state-expression/m-p/1435300#M798243 Gysbert_Wassenaar 2017-12-06T08:11:24Z