Date filter selection to display results in table box

shanmathy — Thu, 10 Feb 2022 08:26:23 GMT

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)'
];

topic Date filter selection to display results in table box in App Development

Date filter selection to display results in table box