topic Set a field as a variable?? in QlikView

Set a field as a variable??

Tue, 03 Jul 2012 13:17:18 GMT

In my current model im trying to set a variable to read data from a column in an excel sheet. Im trying to set the field name as the variable so that if the data changes, it wont affect the variable being read by a where condition. It saves me having to hard code data.

i tried "let vCost=COST(which is the field name) but it doesnt seem to work in practice.

any advice?

Re: Set a field as a variable??

MayilVahanan — Tue, 03 Jul 2012 13:52:57 GMT

Hi,

Try this,

Set vCost = Cost;

The Set command assigns the variable the text to the right of the equal sign, whereas the Let command evaluates the expression.

Hope it helps

Re: Set a field as a variable??

Tue, 03 Jul 2012 14:01:47 GMT

Hi,

The field "COST" contains a thousand rows of data. So I would like to create a variable to account for all the data. If that makes sense.