Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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.