Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kinjal1645
Creator
Creator

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
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
Creator
Creator
Author

They are connected through testID.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator
Creator
Author

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

kinjal1645
Creator
Creator
Author

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

1.GIF

2.GIF

Can you help?!

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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.