topic Re: Get the value with filter by variable without (SUM, COUNT, MAX) in App Development https://community.qlik.com/t5/App-Development/Get-the-value-with-filter-by-variable-without-SUM-COUNT-MAX/m-p/1029046#M15715 <HTML><HEAD></HEAD><BODY><P>I don't think i understand your questions. Do you mind re-explaining what you trying to get?</P></BODY></HTML> Wed, 27 Apr 2016 15:37:28 GMT sunny_talwar 2016-04-27T15:37:28Z Get the value with filter by variable without (SUM, COUNT, MAX) https://community.qlik.com/t5/App-Development/Get-the-value-with-filter-by-variable-without-SUM-COUNT-MAX/m-p/1029045#M15714 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I have a table with a month number &amp; month description (used to filter data)</P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid #000000; width: 88px; height: 109px;" width="86"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>No</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Months</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">January</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">Februar</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">March</TD></TR><TR><TD style="padding: 2px;">..</TD><TD style="padding: 2px;">...</TD></TR></TBODY></TABLE><P></P><P>In a variable I have the number of the month : (no selection = number of th current mont, &gt;1 selection = max number).</P><P>=IF(GetSelectedCount(TIME_DESC)1,Month(Today()),IF(GetSelectedCount(TIME_DESC)&gt;1,Max(TIME_MONTHUM),TIME_MONTHUM))</P><P></P><P>But I need to have the in a other or same variable the description of the month number</P><P>Something like this : <SPAN style="font-size: 10pt; line-height: 1.5em;">(TIME_MONTHUM=$(=vPeriod),TIME_DESC)</SPAN></P><P></P><P>How to get the value with filter (without any SUM, COUNT)</P><P></P><P>Best regards</P></BODY></HTML> Wed, 27 Apr 2016 11:37:21 GMT https://community.qlik.com/t5/App-Development/Get-the-value-with-filter-by-variable-without-SUM-COUNT-MAX/m-p/1029045#M15714 2016-04-27T11:37:21Z Re: Get the value with filter by variable without (SUM, COUNT, MAX) https://community.qlik.com/t5/App-Development/Get-the-value-with-filter-by-variable-without-SUM-COUNT-MAX/m-p/1029046#M15715 <HTML><HEAD></HEAD><BODY><P>I don't think i understand your questions. Do you mind re-explaining what you trying to get?</P></BODY></HTML> Wed, 27 Apr 2016 15:37:28 GMT https://community.qlik.com/t5/App-Development/Get-the-value-with-filter-by-variable-without-SUM-COUNT-MAX/m-p/1029046#M15715 sunny_talwar 2016-04-27T15:37:28Z Re: Get the value with filter by variable without (SUM, COUNT, MAX) https://community.qlik.com/t5/App-Development/Get-the-value-with-filter-by-variable-without-SUM-COUNT-MAX/m-p/1029047#M15716 <HTML><HEAD></HEAD><BODY><P>I have resolve my issue with "ONLY"</P><P>only({$&lt;DashboardID={$(vDashboardIDForced)}&gt;}DashboardNameFR_DDB)</P><P></P><P>Thanks guys</P></BODY></HTML> Mon, 02 May 2016 06:43:39 GMT https://community.qlik.com/t5/App-Development/Get-the-value-with-filter-by-variable-without-SUM-COUNT-MAX/m-p/1029047#M15716 2016-05-02T06:43:39Z Re: Get the value with filter by variable without (SUM, COUNT, MAX) https://community.qlik.com/t5/App-Development/Get-the-value-with-filter-by-variable-without-SUM-COUNT-MAX/m-p/1029048#M15717 <HTML><HEAD></HEAD><BODY><P>Awesome, I am glad you got it working. Please close this thread by marking your own answer as correct <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 02 May 2016 15:43:32 GMT https://community.qlik.com/t5/App-Development/Get-the-value-with-filter-by-variable-without-SUM-COUNT-MAX/m-p/1029048#M15717 sunny_talwar 2016-05-02T15:43:32Z