topic Re: Creating a new field from expression and passing value in QlikView

Creating a new field from expression and passing value

aetingu12 — Wed, 05 Sep 2018 09:46:45 GMT

Dear all,

I have a created a simple listbox called Views by writing this expression :

=ValueList('a','b')

Basically, I want tp pass the selection to another field to do calculations. ie if a is selected then I should be able to refer to it from another expression by writing something like:

if(view = a, sum(sales), if(view = b, cost,null))

Any guidance would be more than appreciated.

Regards,

Aksel

Re: Creating a new field from expression and passing value

kaushiknsolanki — Wed, 05 Sep 2018 09:55:02 GMT

Hi,

Check this link.

Missing Manual - ValueLoop() & ValueList()

Regards,

Kaushik Solanki

Re: Creating a new field from expression and passing value

jonathandienst — Wed, 05 Sep 2018 10:24:59 GMT

Valuelist() values are not fields and so they cannot be selected.

Re: Creating a new field from expression and passing value

rajivmeher — Wed, 05 Sep 2018 10:35:44 GMT

Hi aetingu12‌

If I understand right, you want to change a field in your calculation based on a listbox selection (correct me if I am wrong).

You can achieve it in another way. Use a inline load with selections you want to do as follows:

CalcSwitch:

Load * inline

[

%ColLabel,%ColName

'a','sum(sales)'

'b','cost'

];

2. Use %ColLabel in a listbox. You will be using this to change your calculation selection.

3. In calculation use the following:

$(=%ColName)

This will change the calculation based on your selection as per what you mention in the inline table.

Regards

Rajiv.

Re: Creating a new field from expression and passing value

aetingu12 — Wed, 05 Sep 2018 11:00:20 GMT

Much appreciated. Exactly what I wanted to do! Thank you.

Re: Creating a new field from expression and passing value

HirisH_V7 — Wed, 05 Sep 2018 11:26:47 GMT

Hi Aksel ,

Value List can be used only to create synthetic dimension, But even if u want it to get it such way means. you can create a field from your Scriptside using match function.

=If(MATCH(Customer,'A-2-Z Solutions','Aadast'),'A',
If(MATCH(Customer,'A Superior System','A&R Partners'),'B','Other'))

Regards,

Hirish