Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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