List box showing only fields that have a current selection

olivetwist — Mon, 06 Nov 2017 16:35:25 GMT

I have a table with 50+ fields in it. many of those fields are people's names. I am trying to create an object that will list only the fields that contain the searched name. if that persons name is in 4 of the 50 fields, list only the 4 fields.

I am ultimately trying to get to an object such as a table or chart that will reduce down to or conditionally display the fields and data associated to the searched name. All other fields should hide.

Any ideas?

Re: List box showing only fields that have a current selection

marcus_sommer — Tue, 07 Nov 2017 13:29:52 GMT

Going to your real goal I could imagine that a visibility-condition (set for each dimension) like:

wildmatch(concat(ThisField, ','), '*$(vSearchValue)*')

or maybe

wildmatch(concat(ThisField, ','), '$(='*' & concat(SearchField, '*' & chr(39) & ',' & chr(39)))')

may work.

Another way might be to use expressions with something like: only(Field) for the names and hiding them with suppressing of NULL within the tab presentation.

Beside this I would consider to merge all those names within a single field by transforming the data with The Crosstable Load.

- Marcus

topic List box showing only fields that have a current selection in QlikView

List box showing only fields that have a current selection

Re: List box showing only fields that have a current selection