topic Re: function getPossibleValues add values in QlikView

function getPossibleValues add values

Thu, 20 Feb 2014 09:53:05 GMT

Hi,

I have found a function that returned the possible values (getPossibleValues). Is possible add more values to this object and then call to a function that set the values again? (setPossibleValues or similar)

Thanks

Re: function getPossibleValues add values

sundarakumar — Thu, 20 Feb 2014 09:56:56 GMT

Can u explain what kind of additions or what conditions u would use with the getpossiblevalues to create a setpossiblevalues bec i think what u look for can be done with triggers.

-Sundar

Re: function getPossibleValues add values

Gysbert_Wassenaar — Thu, 20 Feb 2014 09:58:14 GMT

There's no setpossiblevalues function. There are actions you can add to for example buttons and field triggers. It sounds like you want to use the Select in Field action. And use as search string something like:

='(' & concat(distinct chr(34) & MyFieldHere & chr(34), '|') & '|"Some Extra Value 1"|"Some Extra Value 2"|...etc )'

Re: function getPossibleValues add values

Thu, 20 Feb 2014 10:09:49 GMT

this is my code but i think it's not possible what i want to do....

sub SELECT_PRODUCT_AUX()

set qvDoc = ActiveDocument

rem //Actualizamos el producto auxiliar

set productField = qvDoc.GetField("Producto_Id")

set selectedFields = productField.getSelectedValues()

set productAuxField = qvDoc.GetField("Producto_Id2")

productAuxField.selectValues selectedFields

rem //Añadimos los posibles valores de los almacenes de inventario a los ya almacenes posibles por el resto

set locationField = qvDoc.getField("Almacen_Id")

set possibleFields = locationField.GetPossibleValues()

set locationAuxField = qvDoc.getField("Almacen_Id2")

set possibleFieldsAux = locationAuxField.GetPossibleValues()

rem // número de posibles elementos iniciales

int numElem = selectedFields.Count

rem //Añadimos los nuevos elementos

for i=1 to possibleFieldsAux.Count

possibleFields.add()

int j=1

for i=numElem to numElem + possibleFieldsAux.Count-1

possibleFields(i).Text=possibleFieldsAux(j).Text

possibleFields(i).IsNumeric = false

j=j+1

rem here It should be the code that adds other possible value to the Producto_Id field but i don't know i

end sub

Re: function getPossibleValues add values

Thu, 20 Feb 2014 10:15:14 GMT

Thanks Gysbert,

i was trying to do it, but i think it's not possible:

sub SELECT_PRODUCT_AUX()

set qvDoc = ActiveDocument

rem //Actualizamos el producto auxiliar

set productField = qvDoc.GetField("Producto_Id")

set selectedFields = productField.getSelectedValues()

set productAuxField = qvDoc.GetField("Producto_Id2")

productAuxField.selectValues selectedFields

rem //Añadimos los posibles valores de los almacenes de inventario a los ya almacenes posibles por el resto

set locationField = qvDoc.getField("Almacen_Id")

set possibleFields = locationField.GetPossibleValues()

set locationAuxField = qvDoc.getField("Almacen_Id2")

set possibleFieldsAux = locationAuxField.GetPossibleValues()

rem // número de posibles elementos iniciales

int numElem = selectedFields.Count

rem //Añadimos los nuevos elementos

for i=1 to possibleFieldsAux.Count

possibleFields.add()

int j=1

for i=numElem to numElem + possibleFieldsAux.Count-1

possibleFields(i).Text=possibleFieldsAux(j).Text

possibleFields(i).IsNumeric = false

j=j+1

rem here It should be the code that adds other possible value to the Producto_Id field but i don't know the way to do it

end sub

thanks a lot