Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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