Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Subfield function inside set analysis

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!!

1 Solution

Accepted Solutions

Re: Subfield function inside set analysis

Try adding quotes around the dollar-expansion:

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


talk is cheap, supply exceeds demand
3 Replies

Re: Subfield function inside set analysis

Try adding quotes around the dollar-expansion:

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


talk is cheap, supply exceeds demand
Not applicable

Re: Subfield function inside set analysis

try this

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

or this

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

Not applicable

Re: Subfield function inside set analysis

Gysbert, you´r my hero

It works!!,

Thank you very much.

Community Browser