Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Use Variable in Expression

I want to use a variable to replace "2013 BUDGETV2" in the below expression, what is the correct formula for this?

Sum({<BUDGETID={[2013 BUDGETV2]}>} BUDGETAMT)*-1

THANKS in advance

1 Solution

Accepted Solutions

Re: Use Variable in Expression

Set a variable as

vBudget = 2013 BUDGETV2

Expression

Sum({<BUDGETID={'$(vBudget)'}>} BUDGETAMT)*-1

2 Replies

Re: Use Variable in Expression

Set a variable as

vBudget = 2013 BUDGETV2

Expression

Sum({<BUDGETID={'$(vBudget)'}>} BUDGETAMT)*-1

Re: Use Variable in Expression

Hello,

     Consider your variable name is vVariable then your expression will become like below.

     Sum({<BUDGETID = {"$(vVariable)"}>}BUDGETAMT)*-1

Regards,

Kaushik Solanki