set default month in your expression based on the year/s selected?

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

I am still new to Qlikview and need some assistance especially with Set Analysis.

Lets assume I only have 2 selection options (Year and Months)

The data loaded is cumulative / YTD, meaning if you select Feb, it returns data for Jan & Feb

In view of the above statement, I need a set analysis in my expression to for the following scenarios:

1. In a case where only one YEAR is selected (no months selected), return data for the LastMonthAvailable for the selected YEAR

E.g.1 Selection = 2017

Results = December 2017 data (if we have full year data) /

Results = "Last Month Available In 2017" (if for instance we have data for Jan to July, then it should return data for July)

2. In a case where more than one YEAR is selected (no months selected), return data for the LastMonthAvailable of the GreatestYear

E.g.1 Selection = 2017 & 2018

Results = "December 2018" data (if we have full year data) /

Results = "Last Month Available In 2018" (if for instance we have data for Jan to July, then it should return data for July)

3. In a case where a YEAR is selected with (one specific month selected), return data for that specific month.

E.g.1 Selection = 2018 , June

Results = "June 2018" data

4. In a case where a YEAR is selected with (more than one month selected), return data for the GreatestMonth.

E.g.1 Selection = 2018 , June & July

Results = "July 2018" data

Please help me edit this expression to cater for the above statements

=sum(Sales_Amount)

topic set default month in your expression based on the year/s selected? in QlikView