QlikView: Modify Data in Column After in Load Script?
I am not sure if this is something that is possible or not. Here is what is happening. I have several different departments that track their data on Excel. Easy right? Most of the time yes. However, I am kind of nit picky about how I present my reports. While some of the departments use "FY ####" others use "FY##" in their fiscal year column.
So is there a way to fix this this in the load script? If I wanted to have the data for [Effective FY] changed to "FY 2018" when it says "FY18" can I do that?
I am super bad at coding in QlikView so any help would be appreciated.
I would be changing all of the imported data to [Fiscal Year] actually. Effective FY is one of the fun column names that someone in the departments uses since they data sometimes goes over multiple fiscal years.