Passing variable through function in set analysis

[tiyasa125]

Hi All,

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. .

here you have the set.

=num(only({<[STATUS DATE]= {'$(=Max([STATUS DATE]))'}, NAME={'$(=upper($(vPRDManualData))'}>}

[Product Requirement Average]),'# ##0,0%')

The value for this variable is coming from a if formula. I have checked it is working fine in text box. But not sure the reason for not working inside the set. Please help me for this. Many Thanks. .

[tiyasa125]

Yes. It was not for the upper the issue was with relationship. Thanks All .