Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

problem with a sum , problema con una suma

Good evening I have the following fields with their corresponding values:

months    {January, February, March}

year        {2010, 2011, 2012}

sales      {100,200,300,400,400,500}

 

and the following variables

 

dimension_Name

dimension_value1 = FieldValue (dimension_name, 1)

dimension_value2 = FieldValue (dimension_name, 2)

dimension_value3 = FieldValue (dimension_name, 3)

 

with two buttons assign the value for the variable "dimension_Name" can be "month" or "year"

 

you can write the following sum...

= SUM ({<Year={2010}>} [sale])

using variables? something like:

= SUM ({<$(dimension_name)={dimension_value1}>} [sale])

I tried, but so far does not work, anyone know how?

 

thank you very much

_________________________________

Buenas noches tengo los siguientes campos con sus correspondientes valores:

mes  {enero, febrero, marzo}

año  {2010, 2011, 2012}

venta {100,200,300,400,400,500}

y las siguientes variables

dimension_name

dimension_value1 = Fieldvalue(dimension_name,1)

dimension_value2 = Fieldvalue(dimension_name,2)

dimension_value3 = Fieldvalue(dimension_name,3)

con dos botones asigno el valor para la variable "dimension_name" que puede ser "mes" o "año"

es posible escribir la siguiente suma:

=SUM({<Year={2010}>}[venta])

haciendo uso de variables? algo como:

=SUM({<$(dimension_name)={dimension_value1}>}[venta])

he intentado, pero hasta el momento no me funciona, alguien sabe como hacerlo?

Muchas gracias

___________________________________________________________________________________

1 Reply
Not applicable

Re: problem with a sum , problema con una suma

well, I think I found the solution to the problem, the function is:

 

= SUM ({<$(dimension_Name) = {$(dimension_value1)}>}sales)

 

but if there is a better answer, I would like to know,

 

Thanks!

___________________________________________________________

bueno, creo que encontre la solucion al problema, la funcion es:

 

= SUM ({<$(dimension_Name) = {$(dimension_value1)}>}sales)

pero si hay una respuesta mejor, me gustaria conocerla,

gracias.

Community Browser