https://community.qlik.com/t5/App-Development/Question-about-dates-Use-Value-of-variable-in-formula/m-p/2011961#M83670 <TABLE border="1" width="56.25%"> <TBODY> <TR> <TD width="25%" height="25px">ID Client</TD> <TD width="25%" height="25px">Distribution year</TD> <TD width="25%" height="25px">Amount</TD> </TR> <TR> <TD width="25%" height="40px"> <P>1</P> </TD> <TD width="25%" height="40px">2024</TD> <TD width="25%" height="40px">100</TD> </TR> <TR> <TD width="25%" height="25px">2</TD> <TD width="25%" height="25px">2025</TD> <TD width="25%" height="25px">200</TD> </TR> <TR> <TD width="25%" height="25px">3</TD> <TD width="25%" height="25px">2024</TD> <TD width="25%" height="25px">300</TD> </TR> <TR> <TD width="25%" height="25px">4</TD> <TD width="25%" height="25px">2023</TD> <TD width="25%" height="25px">450</TD> </TR> <TR> <TD width="25%" height="25px">5</TD> <TD width="25%" height="25px">2025</TD> <TD width="25%" height="25px">220</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Hi Guys, can you help me please im on Qlik sense</P> <P>I have also created a variable (vDistributionYear) see attached picture with drop down, they can select "1 year" ,"2 years", "3 years", "4 years" ...</P> <P>If they selected "2 years" i want they see lines with distribution year 2023 and 2024</P> <P>If they selected "3 years" i want they see only lines with distribution year 2023,2024,2025 etc</P> <P> </P> <P>Thanks in advance for your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 02 Dec 2022 09:45:43 GMT Sarah5 2022-12-02T09:45:43Z https://community.qlik.com/t5/App-Development/Question-about-dates-Use-Value-of-variable-in-formula/m-p/2011961#M83670 <TABLE border="1" width="56.25%"> <TBODY> <TR> <TD width="25%" height="25px">ID Client</TD> <TD width="25%" height="25px">Distribution year</TD> <TD width="25%" height="25px">Amount</TD> </TR> <TR> <TD width="25%" height="40px"> <P>1</P> </TD> <TD width="25%" height="40px">2024</TD> <TD width="25%" height="40px">100</TD> </TR> <TR> <TD width="25%" height="25px">2</TD> <TD width="25%" height="25px">2025</TD> <TD width="25%" height="25px">200</TD> </TR> <TR> <TD width="25%" height="25px">3</TD> <TD width="25%" height="25px">2024</TD> <TD width="25%" height="25px">300</TD> </TR> <TR> <TD width="25%" height="25px">4</TD> <TD width="25%" height="25px">2023</TD> <TD width="25%" height="25px">450</TD> </TR> <TR> <TD width="25%" height="25px">5</TD> <TD width="25%" height="25px">2025</TD> <TD width="25%" height="25px">220</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Hi Guys, can you help me please im on Qlik sense</P> <P>I have also created a variable (vDistributionYear) see attached picture with drop down, they can select "1 year" ,"2 years", "3 years", "4 years" ...</P> <P>If they selected "2 years" i want they see lines with distribution year 2023 and 2024</P> <P>If they selected "3 years" i want they see only lines with distribution year 2023,2024,2025 etc</P> <P> </P> <P>Thanks in advance for your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 02 Dec 2022 09:45:43 GMT https://community.qlik.com/t5/App-Development/Question-about-dates-Use-Value-of-variable-in-formula/m-p/2011961#M83670 Sarah5 2022-12-02T09:45:43Z https://community.qlik.com/t5/App-Development/Question-about-dates-Use-Value-of-variable-in-formula/m-p/2012164#M83677 <P>Hi </P> <P>Can you describe your variable VdistributionYear please ? how it is built ? </P> Fri, 02 Dec 2022 14:56:54 GMT https://community.qlik.com/t5/App-Development/Question-about-dates-Use-Value-of-variable-in-formula/m-p/2012164#M83677 brunobertels 2022-12-02T14:56:54Z