Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ramu_i
Contributor III
Contributor III

Based on the joining date, who is joining current year and Last 6 months ID are marked color

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:

Capture.PNG

 

Thank you.

Ram

2 Solutions

Accepted Solutions
durgesh22
Creator
Creator

@Ramu_i 

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())

durgesh22_0-1652415323520.png

 

View solution in original post

durgesh22
Creator
Creator

Adjust date range as per your requirement

View solution in original post

2 Replies
durgesh22
Creator
Creator

@Ramu_i 

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())

durgesh22_0-1652415323520.png

 

durgesh22
Creator
Creator

Adjust date range as per your requirement