topic Re: Split string to create filters in QlikView

Split string to create filters

kinjal1645 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I want to create individual listbox/filter - project, setup and testname from column "Parameter" i.e project listbox, setup listbox and testname listbox.

I have attached dummy app.

Kindly help.

Thank you!

Re: Split string to create filters

sunny_talwar — Tue, 22 May 2018 21:48:26 GMT

But which Project is associated with which setup and which testname? Do they need to have any relation between them or if you select a setup, the other two become null?

Re: Split string to create filters

kinjal1645 — Tue, 22 May 2018 22:47:22 GMT

They are connected through testID.

Re: Split string to create filters

rwunderlich — Wed, 23 May 2018 00:09:15 GMT

Use a GENERIC load like this:

table1:

Generic

LOAD

testID,

SubField(Parameter,'#',1),

SubField(Parameter,'#',2)

INLINE [

testID, Parameter

001, testname#abc1

001, setup#lab

001, project#P1

002, testname#abc2

002, setup#lab

002, project#P2

003, testname#djt

003, setup#site

003, project#P3

];

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Split string to create filters

kinjal1645 — Wed, 23 May 2018 13:16:01 GMT

Thanks Rob but is there any other way to do this instead of changing script may be using expressions?

Re: Split string to create filters

kinjal1645 — Wed, 23 May 2018 14:46:02 GMT

I used "=subfield(if (wildMatch(Parameter,'*project*'),Parameter ),'#',2)" but couldn't create association between filters:

Can you help?!

Re: Split string to create filters

rwunderlich — Wed, 23 May 2018 16:07:37 GMT

I can't think of any reasonable way to do this without changing the script.

-Rob

Re: Split string to create filters

sunny_talwar — Wed, 23 May 2018 16:10:58 GMT

It might be very inconvenient but can we use Alternate states to make it work somehow?

Re: Split string to create filters

rwunderlich — Wed, 23 May 2018 16:33:51 GMT

stalwar1‌ I said "reasonable" .

Re: Split string to create filters

sunny_talwar — Wed, 23 May 2018 16:36:02 GMT

Wasn't questioning your response, but was curious if at all it is possible (using alternate state) . By the way you are coming to Philly for Master Summit. I am keeping my fingers crossed that I am in the US to be able to make it to the Summit.