If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi All,
Emp data is there, Joining date, DOB,Name,ID,Place ...
Based on the joining date emp entire row will indicate the color.
Input:
| Emp ID | EMP Name | Joining Date | Pkg | Place | DOB | Qualification | MGR | who is interviwing |
| 1 | A | 01-05-2022 | ||||||
| 2 | B | 02-05-2021 | ||||||
| 3 | C | 03-05-2020 | ||||||
| 4 | D | 04-05-2019 | ||||||
| 5 | E | 05-05-2022 | ||||||
| 6 | F | 06-05-2012 | ||||||
| 7 | G | 07-05-2022 | ||||||
| 8 | H | 08-05-2022 | ||||||
| 9 | I | 09-05-2015 | ||||||
| 10 | J | 10-05-2020 | ||||||
| 11 | K | 11-05-2021 |
Required Output:
Thank you.
Ram
2 Solutions
Accepted Solutions
Use below expression in background color expression in column properties of table for all the columns.
if (Date#(Joining_Date,'DD-MM-YYYY')> AddMonths(today(),-1) and Year(Date#(Joining_Date,'DD-MM-YYYY'))=Year(today()),Yellow())
