topic Re: variable in QlikView

variable

upaliwije — Sun, 05 Jan 2014 15:39:27 GMT

I have created the following expression using ENetProfit as a variable. But It is not working. Pls help me to trace where I have gone wrong

SUM( {$<YEAR = {"$(=Only([YEAR]))"}>} [ENetProfit])

rustyfishbones — Sun, 05 Jan 2014 15:47:15 GMT

what is the variable?

can you share the expression within the Variable

upaliwije — Sun, 05 Jan 2014 15:50:48 GMT

(sum( {<NOTE = {'100'}>}[ACTUAL] )*-1)

this is my expression for variable

rustyfishbones — Sun, 05 Jan 2014 15:53:29 GMT

it wont work, why not create a variable for the whole thing

EOnlyYearNetProfit

sum( {<NOTE = {'100'},YEAR = {"$(=Only([YEAR]))"} >}[ACTUAL] )*-1)

Anonymous — Sun, 05 Jan 2014 22:31:43 GMT

You should save only the set expression that is enclosed in the angle brackets "<>" into a variable. So vNetProfit should be

vNetProfit = NOTE = {'100'}

So your base equation would be eNetProfit = SUM({$<$(vNetProfit)>}[ACTUAL]*-1).

When you expand upon it then it would look like this.

eNetProfittByYearOnly = SUM({$<$(vNetProfit),YEAR = {"$(=Only([YEAR]))"}>}[ACTUAL]*-1).

brijesh1991 — Mon, 06 Jan 2014 04:50:42 GMT

if your year is fiscal year i.e 2013-14, then

SUM( {$<YEAR = {'$(=Only(YEAR))'}>} [ENetProfit])

if your year is normal year i.e 2014, then

SUM( {$<YEAR = {'$(=Max(YEAR))'}>} [ENetProfit])