topic Historical values - react to only specific selections in QlikView https://community.qlik.com/t5/QlikView/Historical-values-react-to-only-specific-selections/m-p/541251#M202318 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>in principle, this is quite easy:</P><P>- By using the {1} parameter, I first make the values displayed in my "historical values" chart independent of selections.</P><P>- =&gt; Then I add two set_expressions defining the year and week for which the value should be displayed.</P><P>- =&gt; Last, I add <STRONG>Werk = P(Werk) </STRONG>to make the values react to selections in the selection_listbox of that field</P><P></P><P>&lt;=&gt; It doesn't work like that: Last week (week_3), there is data to be displayed only for one of the three plants we have available in the listbox <STRONG>Werk, </STRONG>the other two are grey =&gt; when I add that last bit to the set_expression, the chart goes whoof (it disappears). When I delete it again, there is my chart.</P><P></P><P>=&gt; Is there another set_operator I might use instead?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Tue, 21 Jan 2014 09:26:13 GMT datanibbler 2014-01-21T09:26:13Z Historical values - react to only specific selections https://community.qlik.com/t5/QlikView/Historical-values-react-to-only-specific-selections/m-p/541251#M202318 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>in principle, this is quite easy:</P><P>- By using the {1} parameter, I first make the values displayed in my "historical values" chart independent of selections.</P><P>- =&gt; Then I add two set_expressions defining the year and week for which the value should be displayed.</P><P>- =&gt; Last, I add <STRONG>Werk = P(Werk) </STRONG>to make the values react to selections in the selection_listbox of that field</P><P></P><P>&lt;=&gt; It doesn't work like that: Last week (week_3), there is data to be displayed only for one of the three plants we have available in the listbox <STRONG>Werk, </STRONG>the other two are grey =&gt; when I add that last bit to the set_expression, the chart goes whoof (it disappears). When I delete it again, there is my chart.</P><P></P><P>=&gt; Is there another set_operator I might use instead?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Tue, 21 Jan 2014 09:26:13 GMT https://community.qlik.com/t5/QlikView/Historical-values-react-to-only-specific-selections/m-p/541251#M202318 datanibbler 2014-01-21T09:26:13Z