topic Re: Selection modification in QlikView

Selection modification

Luke_Killer_IT — Thu, 31 Mar 2022 09:39:40 GMT

Hello ,

I have this question, if I have a record selected in one of the worksheets for example as shown in the screenshot

I can modify the selection with a button where it shows me, for example, in the next table all records only with the initial 5 characters?

Re: Selection modification

MarcoWedel — Wed, 30 Mar 2022 19:25:50 GMT

can you provide an example of how your expected result would look like?

Re: Selection modification

Luke_Killer_IT — Thu, 31 Mar 2022 09:38:44 GMT

Of course I can,

I select a data at the beginning

Then by pressing the button

You have to flirt in a new table of 5 characters

Re: Selection modification

Luke_Killer_IT — Thu, 31 Mar 2022 09:50:20 GMT

@MarcoWedel

I wanted to make such an action in the button but it doesn't work 😞

Re: Selection modification

Luke_Killer_IT — Thu, 31 Mar 2022 10:23:20 GMT

I managed to find a search error, but it still does not solve the problem. Is it possible to read the currently selected data?

Re: Selection modification

marcus_sommer — Thu, 31 Mar 2022 16:13:18 GMT

You may use something like this:

$(=left(getfieldselections(Artikel), 5)&"*")

or maybe

=wildmatch(Artikel, $(=left(getfieldselections(Artikel), 5)&"*"))

- Marcus

Re: Selection modification

MarcoWedel — Fri, 01 Apr 2022 16:02:51 GMT

maybe like this:

hope this helps

Marco

Re: Selection modification

marcus_sommer — Fri, 01 Apr 2022 16:58:19 GMT

Probably there exists already some categorization to these article. But if they aren't specific enough you could create multiple ones within the script, maybe by splitting the parts by any delimiters or also just from the lengths.

Usually this could deduced from a dimension-table so the efforts and performance-impact would be not essentially - even by two dozens of them. And then you use them within dimension-groups in list-boxes but also in charts. IMO such an approach is much more handy as applying selection-logic with buttons.

- Marcus