topic Re: How to display data based on current selection in QlikView

How to display data based on current selection

Vinod — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

How to display last 1 year data Based on current selection month.
Example - if I select February month of 2019 year, It should display March 2018 to Feb 2019 data.

Thanks,
Vinod

Re: How to display data based on current selection

tresB — Tue, 30 Apr 2019 07:01:46 GMT

You can use set analysis to get it. Try to share your sample app to get more specified expression.

Re: How to display data based on current selection

Vegar — Tue, 30 Apr 2019 07:19:20 GMT

You can accomplish this by implementing set analysis into your expression.
See my example below. Please observ that you should clear all selectable calendar fields. I cleared Year, YearMonth and Month, but you should adjust these to your field names.

=SUM({<
YearMonth,
Month,
Year,
DateField = {">=$(=monthstart(max(DateField),-11)) <=$(=max(DateField))"}
>} YourValueField)