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
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).
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.
