topic Dynamically name a field in set analysis in QlikView

Dynamically name a field in set analysis

afbraga1 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm trying to do something that is not working, although I'm not too sure it is even possible in the first place.

What I'm attempting to do is dynamically create a field in a set analysis, so that it will be a different field depending on the selected scenario. Example:

Let's assume I have a field named OrderDate with the values Request and Confirmed.
Then, I have another two fields named OrderDateRequest and OrderDateConfirmed.

In the set analysis I would like to do the following:

sum(<{OrderDate$(OrderDate)={'20/02/2018'}>}#Volume)

Is it possible, to dynamically name a field like this? So that when I select Request or Confirmed on OrderDate it be selecting a values from different fields.

Thank you.

Best Regards,

André Braga

Re: Dynamically name a field in set analysis

ogautier62 — Thu, 30 Aug 2018 09:49:42 GMT

Hi,

you could add a variable like :

vField = if(GetFieldSelections(OrderDate)='Request','OrderDateRequest','OrderDateConfirmed')

then sum( {< $(v) = {xxxxxxxxx} volume)

regards

Re: Dynamically name a field in set analysis

afbraga1 — Thu, 30 Aug 2018 14:48:32 GMT

Hello Olivier,

I did manage to solve it by creating 2 variables for this - $(OrderDate) which has as value the OrderDate field, and the second variable $(OrderBacklogDate) with the value ='OrderDate'&$(OrderDate).

By using $(OrderBacklogDate)={'20/02/2018'}, I have now the desirable outcome.

Your example didn't fully reflect my intent, partly because the value selections of the OrderDate field, do not reflect the name of the fields I wanted to portray. Nonetheless it really helped me expand my thought horizon and create new ideas on how to tackle the issue. Thank you!!

Best Regards,

André Braga