topic Re: Use Variable in Expression in QlikView

Use Variable in Expression

Thu, 14 Mar 2013 13:03:03 GMT

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

CELAMBARASAN — Thu, 14 Mar 2013 13:08:17 GMT

Set a variable as

vBudget = 2013 BUDGETV2

Expression

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

kaushiknsolanki — Thu, 14 Mar 2013 13:08:18 GMT

Hello,

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

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

Regards,

Kaushik Solanki