topic Re: Select Field with two variables in QlikView

Select Field with two variables

spividori — Sat, 16 Nov 2024 17:34:40 GMT

Hi.

In my application I set the variables "Weight From" and "Weight To" and I need to select the AnimalIDs that are within that weight range wite a button Action. As seen in the image

Regards.

Re: Select Field with two variables

edwin — Tue, 26 Jan 2021 14:57:38 GMT

if the ask is to add this business logic in your expression, add it in set analysis:

sum({<WEIGHT={">=$(vWeightFrom)<=$(vWeightTo)"}>}yourmeasure)

Re: Select Field with two variables

spividori — Tue, 26 Jan 2021 17:45:19 GMT

Hi Edwin.

Thanks for answering.

I need to select the IdAnimal whose weight is within that range.

I had thought of button action.

Regards.

Re: Select Field with two variables

spividori — Tue, 26 Jan 2021 22:54:57 GMT

I have achieved it through a button action, with the following macro:

Sub Selection
vFirst= ActiveDocument.Variables("vPesoDesde").GetContent.String
vLast= ActiveDocument.Variables("vPesoHasta").GetContent.String
mySelect= ">=" & vFirst & " <=" & vLast
ActiveDocument.Fields("Peso").Select mySelect
ActiveDocument.Fields("IdAnimal").SelectPossible
ActiveDocument.fields("Peso").Clear
end sub

Regards.

Re: Select Field with two variables

edwin — Wed, 27 Jan 2021 18:06:19 GMT

if that is the behavior you wanted you can use variable triggers in document settings > triggers
choose teh variables in input add action SELECT FIELD, enter animalID and in expression:
='(' & concat({1<Peso={">=$(vPesoDesde)<=$(vPesoHasta)"}>}IdAnimal,'|') & ')'

when you enter a value in teh variables, the action will trigger. to test you want to get the values:
(0111|0123|0234) which are the animal IDs where weight is between the two variables