topic Re: Subfield function inside set analysis in QlikView

Subfield function inside set analysis

Thu, 18 Jul 2013 13:13:49 GMT

Hi dev people,

I have been trying several hours make to work the expression:

=Sum( {< Producto={$(=subfield(vProducto,' (',1))}>} Precio)

In vProducto is stored 'Producto1 (200)'

I have also tried:

=Sum( {< Producto={$(=subfield('Producto1 (200)',' (',1))}>} Precio)

and it does not work either.

If i try:

=Sum( {< Producto={'Producto1'}>} Precio)

it works.

It seems that the subfield expression or the variable is not well resolved. Any ideas?

Thank you!!

Gysbert_Wassenaar — Thu, 18 Jul 2013 13:15:19 GMT

Try adding quotes around the dollar-expansion:

=Sum( {< Producto={"$(=subfield(vProducto,' (',1))"}>} Precio)

Thu, 18 Jul 2013 13:20:19 GMT

try this

=Sum( {< Producto={'$(vProducto)'}>} Precio)

or this

=sum({<product={"$(=subfield(vProducto,'(',1))"}>}Precio)

Thu, 18 Jul 2013 13:20:28 GMT

Gysbert, you´r my hero

It works!!,

Thank you very much.