Split string to create filters

[kinjal1645]

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!

[sunny_talwar]

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]

They are connected through testID.

[rwunderlich]

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]

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

[kinjal1645]

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

Can you help?!

[rwunderlich]

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

-Rob

[sunny_talwar]

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

[rwunderlich]

stalwar1‌ I said "reasonable" . 

[sunny_talwar]

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.