topic Re: Search in Listbox with Formula as Dimension in QlikView

Search in Listbox with Formula as Dimension

chrweber — Wed, 25 Apr 2018 12:03:33 GMT

How do I search advanced in a Listbox with a user defined dimension (via formula).

Re: Search in Listbox with Formula as Dimension

sunny_talwar — Wed, 25 Apr 2018 12:09:49 GMT

When you right click on the list box, you will see the option for advanced search

Re: Search in Listbox with Formula as Dimension

chrweber — Thu, 26 Apr 2018 04:27:42 GMT

Yes, I am well aware of that. And the setup is not the question, rather why associative search does not appear to work if I use a formula as a field (or maybe it is called expression)

Re: Search in Listbox with Formula as Dimension

sunny_talwar — Thu, 26 Apr 2018 08:55:28 GMT

I guess, I am not 100% confident, that you can only do an advanced search against a field from the script... are you not able to create your field in the script?

Re: Search in Listbox with Formula as Dimension

chrweber — Thu, 26 Apr 2018 11:32:59 GMT

Yes. My question is how to use advanced/associative search With a formula.

And if not, I would like some hard verification

Re: Search in Listbox with Formula as Dimension

sunny_talwar — Thu, 26 Apr 2018 11:35:37 GMT

And if not, I would like some hard verification

You seem to be very unhappy . I can look around, but it might be easier for hic‌ to respond if he is available. Or may be marcus_sommer‌, rwunderlich‌, troyansky‌ have ideas here.....

Re: Search in Listbox with Formula as Dimension

chrweber — Thu, 26 Apr 2018 11:38:21 GMT

Not unhappy, just in search for truth.

It might appear to amount to the same thing, but does not. Qlikview is still fun.

Re: Search in Listbox with Formula as Dimension

sunny_talwar — Thu, 26 Apr 2018 11:39:54 GMT

This doesn't prove that you cannot use Advanced search on calculated dimensions, but it specifically points out that it can only be done for QlikView fields

Link: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Advanced_Search_dialog.htm

Re: Search in Listbox with Formula as Dimension

chrweber — Thu, 26 Apr 2018 11:43:00 GMT

Thank you for your taking your time to highlight this.

This will suffice.

Have a nice Day

Re: Search in Listbox with Formula as Dimension

marcus_sommer — Thu, 26 Apr 2018 12:08:06 GMT

Please give an example how the dimension is created, which values they contain and which search-string should be how applied.

- Marcus

Re: Search in Listbox with Formula as Dimension

chrweber — Thu, 26 Apr 2018 12:18:06 GMT

i wish to restrict the list using if

Re: Search in Listbox with Formula as Dimension

marcus_sommer — Thu, 26 Apr 2018 12:23:23 GMT

What doesn't work with your approach? This within the example worked:

- Marcus

Re: Search in Listbox with Formula as Dimension

sunny_talwar — Thu, 26 Apr 2018 12:24:01 GMT

But here the fieldA is never equal to x... so it will show all the FieldA.... if you do this =if([FieldA]<>'a', [FieldA]) I see only b and c....

but was this what you were trying to do? or were you doing a advanced search?

Re: Search in Listbox with Formula as Dimension

chrweber — Thu, 26 Apr 2018 12:26:07 GMT

Please try searching for 1 in the listboxes.

the x is without effect but to have a valid if

Re: Search in Listbox with Formula as Dimension

sunny_talwar — Thu, 26 Apr 2018 12:28:39 GMT

The advanced search window doesn't even open up for a calculated dimension in list box....

Re: Search in Listbox with Formula as Dimension

chrweber — Thu, 26 Apr 2018 12:33:32 GMT

Hence this thread

Re: Search in Listbox with Formula as Dimension

marcus_sommer — Thu, 26 Apr 2018 12:40:22 GMT

In my opinion this couldn't work by the design of this feature which is a search in fields by running through all (enabled) fields respectively system-tables. And the calculated dimension is not a field there ... This meant you need to create this field within the script.

- Marcus