topic Re: Variable as a Dimension ( or Variable Dimension) in QlikView

Variable as a Dimension ( or Variable Dimension)

Fri, 24 Oct 2014 08:39:21 GMT

Hi!

I'm struggling trying to know why this happens:

Dimension (Option A): =if(SupContrato > 26000 , SupContrato, null())

Dimension (Option B): =if(SupContrato > $(Rango4), SupContrato, null())

Option A works perfectly: it lists only the contracts which have a surface higher than 26.000sqm

Option B: I change the 26000 for a variable that I declare within the script:

Set Rango4 = 4*(max(SupContrato)/5); but it does not work because it gets null for everything.

Many thanks for any help

Re: Variable as a Dimension ( or Variable Dimension)

martinpohl — Fri, 24 Oct 2014 08:42:42 GMT

You defined Rango4 by set, so there is a formula, not a value in.

Therefor you need to calculate the variable in the definition

Use

Dimension (Option B): =if(SupContrato > $(=Rango4), SupContrato, null())

Regards

Re: Variable as a Dimension ( or Variable Dimension)

stigchel — Fri, 24 Oct 2014 08:43:23 GMT

Try

$(=Rango4)

The = sign means evaluate the next expression, without text is assumed

Re: Variable as a Dimension ( or Variable Dimension)

kuba_michalik — Fri, 24 Oct 2014 08:44:08 GMT

I think you want that variable calculated globally, not in place when defining the dimension. Put an extra equal sign in front of it:

Set Rango4 ==4*(max(SupContrato)/5);

This will store the equal sign in the variable definition, so it will be calculated like any other variable which begins with =

Re: Variable as a Dimension ( or Variable Dimension)

Fri, 24 Oct 2014 08:48:56 GMT

Thanks Martin! But it does not work neither, I have try that already.

I have also tried to make a LET instead of a Set, but nothing.

Also to declare another variable: Rango4Bis which calls the variable Rango4...nothing neither.

Also to insert the formula of the variable within the dimension instead of the variable...nothing

The only thing that works is to put a figure, not a formula or variable.

It does not make sense to me...any other suggestion?

Many thanks in advance.

BQ.

Borja Quintero.

CBRE Spain. GCS.

Architect.

+34670899622

De: Martin Pohl

Enviado: Friday, October 24, 2014 10:43 AM

Para: Quintero, Borja @ Madrid

Asunto: Re: - Variable as a Dimension ( or Variable Dimension)

Qlik Community<http://community.qlik.com/>

Variable as a Dimension ( or Variable Dimension)

reply from Martin Pohl<http://community.qlik.com/people/MartinPohl?et=watches.email.thread> in Scripting - View the full discussion<http://community.qlik.com/message/640918?et=watches.email.thread#640918>

Re: Variable as a Dimension ( or Variable Dimension)

martinpohl — Fri, 24 Oct 2014 08:55:10 GMT

to check the value of the variable create a straight table chart with the formula from the dimension and check the result by mouse over

Regards