Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sarah5
Contributor
Contributor

Question about dates - Use Value of variable in formula

ID Client Distribution year Amount

1

2024 100
2 2025 200
3 2024 300
4 2023 450
5 2025 220

Hi Guys, can you help me please im on Qlik sense

I have also created a variable (vDistributionYear) see attached picture with drop down, they can select "1 year" ,"2 years", "3 years", "4 years" ...

If they selected "2 years" i want they see lines with distribution year 2023 and 2024

If they selected "3 years" i want they see only lines with distribution year 2023,2024,2025 etc

Thanks in advance for your help 🙂

Labels (1)
1 Reply
brunobertels
Master
Master

Hi

Can you describe your variable VdistributionYear please ? how it is built ?