topic Re: How to get the filter pane value dynamically in a variable in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67007#M788165 <HTML><HEAD></HEAD><BODY><P>Yes, I have checked with GetCurrentSelections() function. In my example it is showing both the field and the selected value as Year(Date ID) : 2017.</P><P></P><P>I only want to show 2017, the selected value</P></BODY></HTML> Wed, 07 Feb 2018 14:15:07 GMT Anonymous 2018-02-07T14:15:07Z How to get the filter pane value dynamically in a variable https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67003#M788161 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a field as [Date ID], I have created a filter pane (Same as list box) as 'year([Date ID])'. Now when a value is selected from the filter pane, I want to show the selected value to the title of the charts. Can I catch the selected value in a variable? Please help if there is any function to do that.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67003#M788161 Anonymous 2020-11-25T16:16:04Z Re: How to get the filter pane value dynamically in a variable https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67004#M788162 <HTML><HEAD></HEAD><BODY><P>Something like this in the title field:</P><P></P><P>=Concat(distinct year([Date ID]),',')</P><P></P><P>regarding the variable, can you please explain what you are trying to achieve? </P></BODY></HTML> Wed, 07 Feb 2018 14:10:43 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67004#M788162 lorenzoconforti 2018-02-07T14:10:43Z Re: How to get the filter pane value dynamically in a variable https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67005#M788163 <HTML><HEAD></HEAD><BODY><P>You should be able to use the function GetCurrentSelected() to capture that value. </P><P></P><P>Have you looked at that?</P><P></P><P>Nate</P></BODY></HTML> Wed, 07 Feb 2018 14:11:39 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67005#M788163 hallquist_nate 2018-02-07T14:11:39Z Re: How to get the filter pane value dynamically in a variable https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67006#M788164 <HTML><HEAD></HEAD><BODY><P>Yes, You can. </P><P></P><P><STRONG>=Concat([Date ID], '-')</STRONG></P></BODY></HTML> Wed, 07 Feb 2018 14:12:51 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67006#M788164 Anil_Babu_Samineni 2018-02-07T14:12:51Z Re: How to get the filter pane value dynamically in a variable https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67007#M788165 <HTML><HEAD></HEAD><BODY><P>Yes, I have checked with GetCurrentSelections() function. In my example it is showing both the field and the selected value as Year(Date ID) : 2017.</P><P></P><P>I only want to show 2017, the selected value</P></BODY></HTML> Wed, 07 Feb 2018 14:15:07 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67007#M788165 Anonymous 2018-02-07T14:15:07Z Re: How to get the filter pane value dynamically in a variable https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67008#M788166 <HTML><HEAD></HEAD><BODY><P>Then Work like this?</P><P><STRONG>SubField(</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>GetCurrentSelections(), ' ', -1)</STRONG></SPAN></P></BODY></HTML> Wed, 07 Feb 2018 14:17:36 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67008#M788166 Anil_Babu_Samineni 2018-02-07T14:17:36Z Re: How to get the filter pane value dynamically in a variable https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67009#M788167 <HTML><HEAD></HEAD><BODY><P>Please attach your document.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 07 Feb 2018 14:31:57 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67009#M788167 isingh30 2018-02-07T14:31:57Z Re: How to get the filter pane value dynamically in a variable https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67010#M788168 <HTML><HEAD></HEAD><BODY><P>HI ,</P><P>try below if you want to show only single value.</P><P></P><P><STRONG>&amp; max(Year([Date ID]))&nbsp; </STRONG>along with chart tittle </P><P></P><P>Ex:</P><P><SPAN style="font-size: 10pt;">sales by customer for </SPAN><STRONG style="font-size: 13.3333px;">&amp; max(Year([Date ID]))</STRONG></P></BODY></HTML> Wed, 07 Feb 2018 14:36:24 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-filter-pane-value-dynamically-in-a-variable/m-p/67010#M788168 sasikanth 2018-02-07T14:36:24Z