Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
KharansuESSPL
Contributor II
Contributor II

Customized Year filter

Hi All,

I have a situation where I need to show a table with 3 columns - Country, Re-certification date and Re-certification status.

Twist is, a Year filter should be provided and the status column should change dynamically according to the selection of the Year filter - 

For example –

If 2022 is selected in the filter and some of the Re-Certifications don’t expire in 2022 (Re-Cert. Date is available for 2022) then the Re-Cert. Status shall be updated as ‘Complete’, else it should show the status as in excel and for the past years, if the certification is not extended (not ordered or complete - and nothing further) then the status should show 'expired'

 Similarly, when 2023 is selected, the record numbers shouldn’t change, only the status should be changed for the Re-Cert. Status column

Note - When any of the year is selected, the record numbers should not change, rather the Re-certification status should change

Attached the sample excel.

Thanks,

Kharansu

Labels (2)
0 Replies