topic Re: EXPRESSION in QlikView

EXPRESSION

upaliwije — Wed, 01 Jan 2014 15:38:25 GMT

Hi,

I have created the following expression in a text object and it is working well

=num((Sum({<[NOTE]={100},DEPT={'BRAN'},MONM={'MOTOR'},BRANCH= >}[AMOUNT]))

Now I have also created a variable as follows

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

I want to apply above variable into my expression. Please help me Thanks in Advance

MK_QSL — Wed, 01 Jan 2014 17:04:10 GMT

select a text box and insert below

=EPremium

rustyfishbones — Wed, 01 Jan 2014 17:11:20 GMT

Do you mean you want to add DEPT={'BRAN'},MONM={'MOTOR'},BRANCH= into the variable?

I would create a MyVariable variable for DEPT={'BRAN'},MONM={'MOTOR'},BRANCH=

and then add that into my Expression,something like

(sum( {<NOTE = {'100'}, $(MyVariable)>}[AMOUNT]*-1 ))

upaliwije — Thu, 02 Jan 2014 05:20:02 GMT

My real requirement is to insert variable into this

=num((Sum({<[NOTE]={100},DEPT={'BRAN'},MONM={'MOTOR'},BRANCH= >))

brijesh1991 — Thu, 02 Jan 2014 06:50:53 GMT

Hi,

If you want to give explicit selection by variable, then you can follow exactly like this:

=num((Sum({<EPremium ={'$(createdVariableName)'} , [NOTE]={100},DEPT={'BRAN'},MONM={'MOTOR'},BRANCH= >}[AMOUNT]))