topic Re: Select in Field with Multiple Field selection and Multiple Value in QlikView

Select in Field with Multiple Field selection and Multiple Value

BrianT — Sat, 16 Nov 2024 02:19:24 GMT

Hi there,

I'm new here, so I just want to ask a question regard the Select in Field function.

I would like to select Multiple Fields in one button for example, when the user click on the text box, the result will return Field 1, Field 2, Field 3 and Field 4, also with each field selecting specific values such as Flagged, Error, and Justified.

I've tried to make multiple Select in Field Actions, but the results are not desirable.

Thanks in advance.

Re: Select in Field with Multiple Field selection and Multiple Value

SergeyMak — Thu, 03 Oct 2019 04:19:33 GMT

Hi Brian,
I think you should explain a bit, what results you are having. It would be also great to see a sample of your data set.
It seems correct of what you are doing. You might have a problem with that if your selections are exclusive. eg you have records Flagged, Error, but not Justified.
Try to make those selections manually in listboxes.

Hope it helps.

Re: Select in Field with Multiple Field selection and Multiple Value

BrianT — Thu, 03 Oct 2019 06:02:49 GMT

Hi Sergey,

The sample data set is

Field 1: Flagged, Error, Justified
FIeld 2: Marked, Incomplete, OK
Field 3: Flag, Mistake, Good
Field 4: Wrong, Transition, Go

So I've tried to use Select in Field under action in a text box in this order,

Field: Field 1, Search String: Flagged
Field: Field 2, Search String: Marked
Field: Field 3, Search String: Flag
Field: Field 4, Search String: Wrong

So they returned only the first one, i think due to the data being exclusive.
Any other recommendation for this problem?

Thanks

Re: Select in Field with Multiple Field selection and Multiple Value

SergeyMak — Fri, 04 Oct 2019 00:54:09 GMT

Hi Brian,

If data is exclusive, you simply can't select it all together.

Then I have a question about your requirements. Why do you need it working in the way you data can't provide?

It wold be great if you give a table, but not just fields values listing.

Re: Select in Field with Multiple Field selection and Multiple Value

BrianT — Fri, 04 Oct 2019 07:29:22 GMT

Hi Sergey,

Because the data compiled comes from multiple source and uses different values that means the same thing. So I want to select something that only means one thing as shown in the example above. In the fields there are only 3 possible values.

I got around the problem by having additional fields that standardises the value that mean one thing.

Thanks for your reply.

Regards

Re: Select in Field with Multiple Field selection and Multiple Value

SergeyMak — Fri, 04 Oct 2019 07:49:57 GMT

Thanks for clarification, Brian.

In your case your solution of 'additional fields that standardises the value' is the only way to go.

That's great, that you've found it by yourself!