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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jacek_k
Contributor III
Contributor III
‎2022-01-03 04:39 PM

How to write proper if statement based on values in all column?

My data:

ID Date Version newColumn
1 1.01.2019 1 2.01.2019
1 2.01.2019 2 2.01.2019

 

What functions I need to use to achive:
1. Take max version for the same ID

2. Add Date 2.01.2019 to all rows.

Labels (4)
Labels
400 Views
0 Likes
0 Replies