topic Re: Passing variable through function in set analysis in QlikView

Passing variable through function in set analysis

tiyasa125 — Sat, 29 Apr 2017 20:17:07 GMT

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

Re: Passing variable through function in set analysis

daveamz — Mon, 01 May 2017 09:33:16 GMT

Hi Tiyasa,

Can you provide a sample data set?

Regards,

David

Re: Passing variable through function in set analysis

stigchel — Mon, 01 May 2017 11:49:59 GMT

You don't need the upper, it is case insensitive, to fix anyway:

You're missing a ) and some quotes for the upper function e.g. upper('string')

=Only({<NAME={'$(=upper('$(vPRDManualData)'))'}>} [Product Requirement Average])

Re: Passing variable through function in set analysis

tiyasa125 — Tue, 02 May 2017 07:13:37 GMT

Hi Piet,

Thanks for your reply but it seems to be not working still.

It saying set analysis error.

Can you please let me know if there is any standard syntax for this scenario.

Many Thanks

Tiyasa.

Re: Passing variable through function in set analysis

Anil_Babu_Samineni — Tue, 02 May 2017 07:23:13 GMT

Would you share sample to look, where this is not working

Re: Passing variable through function in set analysis

tiyasa125 — Tue, 02 May 2017 08:27:01 GMT

Hi,

Here you go.

If you see here I need it to be read from the PRA table in uppercase.

Thanks

Tiyasa.

Re: Passing variable through function in set analysis

tiyasa125 — Tue, 02 May 2017 08:28:31 GMT

Hi,

Here you have the sample file.

I dont need any change in script.

So I need to read the data in uppercase.

Thanks

Tiyasa.

Re: Passing variable through function in set analysis

stigchel — Tue, 02 May 2017 09:19:30 GMT

The syntax checker may suggest there is an error, but as you can see in attached example it is working. You can also see that you don't need the upper.

Re: Passing variable through function in set analysis

tiyasa125 — Tue, 02 May 2017 09:28:11 GMT

Hi,

The value is dynamic and coming through a variable after some string operation.

Thanks

Tiyasa.

Re: Passing variable through function in set analysis

Anil_Babu_Samineni — Tue, 02 May 2017 09:36:14 GMT

Like this?

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

[Product Requirement Fulfilment Documentation]),'# ##0,0%')

Re: Passing variable through function in set analysis

tiyasa125 — Tue, 02 May 2017 13:19:46 GMT

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