topic Select a string field in a table from a variable in App Development

Select a string field in a table from a variable

Eugene81 — Mon, 09 Oct 2023 09:03:08 GMT

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

Re: Select a string field in a table from a variable

ajaykakkar93 — Mon, 09 Oct 2023 09:34:53 GMT

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

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

Re: Select a string field in a table from a variable

Eugene81 — Mon, 09 Oct 2023 13:06:51 GMT

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

Re: Select a string field in a table from a variable

ajaykakkar93 — Tue, 10 Oct 2023 02:53:36 GMT

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

Create variables vMinDate with expression
=date(min([Term Date] ))
Create variables vMaxDate with expression
=date(max([Term Date] ))
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