Select a string field in a table from a variable

[Eugene81]

Hello All,

I have a variable input (dropdown) with month (Vmonth) on a Qlik Sense Sheet

and i would like to filter string value field in a straight table with with this dropdown variable

How do you select a string field (ie Month Details) with another field in the same table which is linked to a variable(ie [Month name] = {$(Vmonth )} ?

Thank you very much in advance

[ajaykakkar93]

Hi,
Add the set analysis in a measure to filter the value

{<[Month Field Name]={"$(Vmonth )"}>}

[Eugene81]

Hello,

Thank you very much for your answer, unfortunately it does not work.
I want the green field on top which is Vmonth to filter month-desc for may in the table (for the example)

{<[month]={"$(Vmonth )"}>} returns blank

[ajaykakkar93]

Hi
below is a example that i have shared please take a look at it it will help you for the same 

Hi,

Lets assume the field [Term Date] has below dates

[Term Date] 

01/12/2022
02/12/2022
03/12/2022
04/12/2022
05/12/2022
etc...

steps

1. Create variables vMinDate with expression
   =date(min([Term Date] ))
2. Create variables vMaxDate with expression
   =date(max([Term Date] ))
3. Then in your measure add a set analysis
   =SUM({<[Term Date] = {">=$(vMinDate)<=$(vMaxDate)"}>}[Profit USD])
   
   Link:
   https://community.qlik.com/t5/New-to-Qlik-Sense/Filter-a-table-with-variables/m-p/2126606#M239060