Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
me2
Contributor
Contributor

pass the filter selected value to one of the formulas in report

Hi.. question on parameters. I am new to Qlik and have a scenario where I have to pass the filter selected value to one of the formulas in my report to get the data.

 

Example: Date filter - 12/31/2018

                                             01/04/2019

 

When a user selects one of the date filter values, for example: 12/31/2018, that should give me YTD sum for 2018 in the output. Lets say they select 01/04/2019, it should give me YTD sum for 2019

3 Replies
Gysbert_Wassenaar

You'll need to make some changes to the expression in your chart (or charts). For example Sum(Amount) would become something like Sum({<MyDate={">=$(=YearStart(Max(MyDate))<=$(=Max(MyDate))"}>}Amount).

talk is cheap, supply exceeds demand
me2
Contributor
Contributor
Author

what will be MyDate?

Gysbert_Wassenaar

Exactly. What will be your MyDate? I have no idea. I don't know your data so I don't know which field in your data is the date field that you need to use in place of MyDate.

talk is cheap, supply exceeds demand