Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have in application a List Box where the user can check columns that they want to see and Chart (Straight Table) where the selected columns are shown.
This works with "Enable Conditional" ticked and the following code
=substringcount ('|'& GetFieldSelections(Dim_, '|', 100)&'|','Test_Result')
Dim_ is the name where Test_Result checkbox is.
The issues is that I also have check box named 'Test Result Status' . Currently the underscore in Test Result is the solution, because, if I remove it ( _ ), as I check "Test Result Status" it would show both of the columns.
So my question is - Is it possible to have this code part that states I wish to see exact match? So I can use such codes and would see one column when ticked:
=substringcount ('|'& GetFieldSelections(Dim_, '|', 100)&'|','Test Result')
<AND>
=substringcount ('|'& GetFieldSelections(Dim_, '|', 100)&'|','Test Result Status')
Hi,
How about putting pipes around your second strings, so;
=substringcount ('|'& GetFieldSelections(Dim_, '|', 100)&'|','|Test Result|')
=substringcount ('|'& GetFieldSelections(Dim_, '|', 100)&'|','|Test Result Status|')
Cheers,
Chris.
Did Chris' post help? If so, do not forget to return to the thread and use the Accept as Solution button on the post to give Chris credit for the assistance and to let other Community Members know this worked. If you are still working on things, leave an update for us.
Here is a link along the lines of what Chris presented from a Design Blog post that may further help:
https://community.qlik.com/t5/Qlik-Design-Blog/The-Search-String/ba-p/1470548
Regards,
Brett