Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

kinjal1645
Contributor

Split string to create filters

Hello,

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

2.GIF

I have attached dummy app.

Kindly help.

Thank you!

9 Replies

Re: Split string to create filters

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?

kinjal1645
Contributor

Re: Split string to create filters

They are connected through testID.

MVP & Luminary
MVP & Luminary

Re: Split string to create filters

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

kinjal1645
Contributor

Re: Split string to create filters

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

kinjal1645
Contributor

Re: Split string to create filters

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

1.GIF

2.GIF

Can you help?!

MVP & Luminary
MVP & Luminary

Re: Split string to create filters

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

-Rob

Re: Split string to create filters

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

MVP & Luminary
MVP & Luminary

Re: Split string to create filters

stalwar1‌ I said "reasonable"

Re: Split string to create filters

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.