Discussion Board for collaboration on QlikView Scripting.
I have four date fields part of the same table:
1. A - Start Date
2. A - Stop Date
3. B - Start Date
4. B - Stop Date
Now while loading this table I want to convert four date fields into two by picking Max dates from ( A- Start Date and B - Start Date) = New Start Date and similarly
max (A-Stop Date and B- Stop Date) = New Stop DAte