topic How to evaluate a variable to a field in an expression in QlikView

How to evaluate a variable to a field in an expression

Wed, 09 May 2012 12:40:49 GMT

I'm sure there's a straightforward answer to this, but I can't find it I'm afraid.

I want to include a variable field in a chart expression.

e.g. suppose the expression is sum( {$<Product = {}>} Sales). It's the Product bit that I want to vary.

So what I want to do is something like sum( {$<field(vVariable) = {}>} Sales), so that by changing vVariable, the expression uses a different field.

I can't seem to evaluate the variable to become an actual reference to a field, if you see what I mean. Can this be done?

Thanks as always

James

How to evaluate a variable to a field in an expression

Wed, 09 May 2012 13:23:20 GMT

He James,

This is possible:

sum( {$<field = {'$(=(vVariable)'}>} Sales)

If you are using a date field you have to make sure that the format of the variable is equal to format of the field.

Good luck.

Frank

How to evaluate a variable to a field in an expression

Wed, 09 May 2012 14:24:00 GMT

James,

I misread your question;

I think you need this:

sum( {$<$(vVariable) = {}>} Sales)

How to evaluate a variable to a field in an expression

Tue, 15 May 2012 17:47:57 GMT

Try this sum($(=vVariable) Sales)