topic Re: Passing a variable to an expression in QlikView

Passing a variable to an expression

Thu, 21 Feb 2013 09:53:58 GMT

Hi there,

I'm having a problem returning a value for my expression below

sum({<TrnMonth={$('vTrnMonthSelected')}>}NetSalesValue)

where TrnMonth is the selection the user makes via a List Box

and vTrnMonthSelected is a variable with the below formula

GetFieldSelections(TrnMonth)

and NetSalesValue is the summed value I want returned.

All I get back is 0.

When I use just $(vTrnMonthSelected) it returns the selections but whenever I run the main sum line, I cannot seem to get it to work.

Any help would be brilliant

Thanks

Re: Passing a variable to an expression

alexandros17 — Thu, 21 Feb 2013 09:56:05 GMT

Use

={$(vTrnMonthSelected)}>} without ' char ... or ={'$(vTrnMonthSelected)'}>}

Hope it helps

Re: Passing a variable to an expression

Thu, 21 Feb 2013 10:01:48 GMT

Unfortunately still not working with :

sum({<TrnMonth={'$(vTrnMonthSelected)'}>}NetSalesValue)

Yeah I know I could just use the sum(NetSalesValues), I wanted to use the formula though to add some logic and this was the first step in getting the completed formula complete, but alas it still doesn't work

Re: Passing a variable to an expression

Thu, 21 Feb 2013 10:02:12 GMT

Nope, neither works unfortunately

Re: Passing a variable to an expression

er_mohit — Thu, 21 Feb 2013 10:05:13 GMT

try this without using variable,

sum({<TrnMonth={"$(=TrnMonth)"}>NetSalesValue)

and for variable create like this:-

vTrnMonthSelected

=(SubField(GetCurrentSelections(),':',-1))

hii sry for late response, try this

THEN,

sum(if(TrnMonth=vTrnMonthSelected,NetSalesValue))

HOPE it helps

Re: Passing a variable to an expression

Thu, 21 Feb 2013 10:23:36 GMT

Your first expression works, I then add the variable like you show,

But the last expression still doesn't work

Re: Passing a variable to an expression

danielrozental — Thu, 21 Feb 2013 12:21:25 GMT

Change your variable from "GetFieldSelections(TrnMonth)" to "=GetFieldSelections(TrnMonth)"