Discussion Board for collaboration on QlikView Scripting.
I need some assistance regarding a problem i am facing.
i currently have two date fields and need to combine them to form a single date field based on the status of the item.
if the item is PIS it should take the PIS date, if the item is anything else but PIS it should take the date created date.
Any ideas would be apreciated
If(Status='PIS',[Date PIS],[Date Created]) as [Combined Date]
Worked like a bomb, thanks Antonio