I need help in Qliksense. I need to have a drop down with three month year dynamically. I have a date field in my table with other fields. if i click on June 2021 from As of date, the table should show the data from the beginning of the data in the DB till june 2021, same way for dec 2021 and dec 2020. Can someone assist on this please
------------------------------
Filter pane for As of date
June 2021
December 2020
December 2021
------------------------
This filter pane should display based on the below if clause
let vFinancialYear=Year(today());
let vPrevious=Year(today())-1;
let vPrevious1=Year(today())-2;
let vCurrentmonth=num(Month(now()));
if('$(vCurrentmonth)'>=6)
then
Load * Inline [
Month, Year
June ,'$(vFinancialYear)'
December , '$(vPrevious)'
June , '$(vPrevious1)'
];
else
Load * Inline [
Month, Year
June ,'$(vPrevious)'
December , '$(vPrevious1)'
June , '$(vPrevious1)'
];