topic Re: can we use a variable in set analysis??? need help pleaseee???? in QlikView

can we use a variable in set analysis??? need help pleaseee????

Fri, 06 Jun 2014 05:47:30 GMT

Hi all,

can someone help me out with below issue please???????

sum({<xoptiontype_={'CALL'}>}(Nominal_Quantity*voption)) where voption is a variable???

because voption is a formula which is very complex consisting of many other variables in it so I stored it as a variable.

Re: can we use a variable in set analysis??? need help pleaseee????

tresB — Fri, 06 Jun 2014 05:49:51 GMT

You can Try with dollar expansion, like:

sum({<xoptiontype_={'CALL'}>} Nominal_Quantity* $(voption) )

Re: Re: can we use a variable in set analysis??? need help pleaseee????

Fri, 06 Jun 2014 05:58:21 GMT

Hi Tresesco,

I tried the same but it doesn't work.I have attached my application for the same.here B is the table which has the expression net call=sum({<xoptiontype_={'CALL'}>} Nominal_Quantity* $(voption) )

and also this voption =net option in the A table

Please can you help??

Re: can we use a variable in set analysis??? need help pleaseee????

jonathandienst — Fri, 06 Jun 2014 06:00:11 GMT

It depends on how you have designed voption. Does it have a leading = sign? If so, then I suggest

sum({<xoptiontype_={'CALL'}>} Nominal_Quantity * (voption))

Otherwise

sum({<xoptiontype_={'CALL'}>} Nominal_Quantity * ($(voption)))

to ensure that the * applies to the whole expression in voption, not just the first term.

HTH

Jonathan

Re: can we use a variable in set analysis??? need help pleaseee????

brijesh1991 — Fri, 06 Jun 2014 06:00:20 GMT

sum({<xoptiontype_={'CALL'}>}(Nominal_Quantity*$(voption)))

Re: can we use a variable in set analysis??? need help pleaseee????

tresB — Fri, 06 Jun 2014 06:03:45 GMT

I don't find a variable called - voption in your app. And if you trying to refer a column from other chart table, you won't be able to. You have to think of alternatives.

Re: can we use a variable in set analysis??? need help pleaseee????

Fri, 06 Jun 2014 06:09:59 GMT

Hi Tresesco,

the variable is present at the last,you can check it.

I am doing the below method:

I have taken an expression from my A table(net option) and made that as a variable (voption)and now trying to substitute that variable in the B table expression(net call)

Re: can we use a variable in set analysis??? need help pleaseee????

tresB — Fri, 06 Jun 2014 06:22:42 GMT

That is not a variable. However, had the reference been from same chart table the similar approach could have been done using Label. As I mentioned earlier you can't refer a chart table column from other chart/object.

Re: can we use a variable in set analysis??? need help pleaseee????

sarvjeet — Fri, 06 Jun 2014 06:33:07 GMT

Hi,

voption is using buy/sell, strikeprice in defination . Add all refrenced dimentions in Table 'B' .

Also use $(voption) instead of voption

This should work.

-Sarvjeet

Re: can we use a variable in set analysis??? need help pleaseee????

Fri, 06 Jun 2014 06:55:07 GMT

ok,

thanks a lot all of you,

I need the referenced columns as well else it will not work as its a calculated expression.learning!!

Re: Re: can we use a variable in set analysis??? need help pleaseee????

Fri, 06 Jun 2014 07:21:55 GMT

Hi ,

I tried the same s you said,I am still not getting the values . in the file attached my last column is the one that is getting calculated. please help.

Re: can we use a variable in set analysis??? need help pleaseee????

Fri, 06 Jun 2014 08:01:07 GMT

I think that the right syntax is:

sum({<xoptiontype_={'CALL'}>}(Nominal_Quantity*$(=voption)))

Re: can we use a variable in set analysis??? need help pleaseee????

Fri, 06 Jun 2014 08:12:57 GMT

Hi Augustin,

I tried the same

it still doesn't work

Re: Re: can we use a variable in set analysis??? need help pleaseee????

Fri, 06 Jun 2014 08:51:00 GMT

Hi,

There is a difference, how you store an expression in a variable with or without an equal sign...

Look at this: http://qlikshare.com/scope-variables-qlik/

You said that variable voption is one complex expression composed of more variables and calculations...
Try to start from bottom up; from this variable, and slowly expanding your expression.

I think that for giving you the right answer, we should also understand your data model and want do you want to do...
Paste your data model.
And tell us if you get any result (calculation) or you don't get calculation at all.

On your place would i start with examining variable voption and it's expression and then build up...

Re: can we use a variable in set analysis??? need help pleaseee????

brijesh1991 — Fri, 06 Jun 2014 09:17:07 GMT

Can you tell what you are storing in variable? let's go from scrach

Take variable into input box and make some selection from other related listbox. Check whether variable value in input box changing accordingly.

Re: can we use a variable in set analysis??? need help pleaseee????

sarvjeet — Fri, 06 Jun 2014 10:31:03 GMT

use Expression in table as :

sum

({<xoptiontype_={'CALL'}>}(Nominal_Quantity))*

$(voption)

and use dimentions : Strike_Price1, buy_sell, strike_price

updated qvw attached

Re: can we use a variable in set analysis??? need help pleaseee????

Mon, 09 Jun 2014 01:37:08 GMT

Hi Sarvjeet,

I did get the result by this method but I also require a line chart with strike_price1 as the dimention and the

net call ie:

({<xoptiontype_={'CALL'}>}(Nominal_Quantity))*$(voption) as the expression.

I need to get a single line graph but that doesnt happen

Re: Re: Re: can we use a variable in set analysis??? need help pleaseee????

Mon, 09 Jun 2014 02:57:12 GMT

hi all.

Please can someone help me out with this issue,I am stuck up and not able to proceed.with your help I am able to get the net values but the graph is not successfull as required.

If you look at my file attached :

Sheet 1-net values come ,but when I try to plot the line graph it doensn't happen.I want it to come as shown in the sheet 2 where when I plot my strike_price1 against my net expression I need to get a single line grapg.

Please help me someone................

Re: Re: Re: can we use a variable in set analysis??? need help pleaseee????

sarvjeet — Mon, 09 Jun 2014 13:45:45 GMT

use this expression :

Sum(AGGR(sum({<xoptiontype_={'CALL'}>}(Nominal_Quantity))* $(voption), [Strike Price],strike_price1, buy_sell))

it will work 🙂

-Sarvjeet

Re: can we use a variable in set analysis??? need help pleaseee????

Mon, 09 Jun 2014 13:57:32 GMT

See the attached file:

I changed strike_price1 to strike_price