I need a help here. I have a qlikview apps where I am doing lookup fact values from a excel file table with reference of another source table.
The excel file data is in uppercase and the source table data is not in a proper format. I cannot change the source table data format to uppercase due to some reason. So I am trying to read the excel file data in uppercase only. I have a variable name vPRDManualData.
Now I am trying to pass this variable through upper function in the set analysis. This is not working. .