topic Re: List Box and Straight table in QlikView

List Box and Straight table

Kunkulis — Sat, 16 Nov 2024 19:37:24 GMT

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:

Re: List Box and Straight table

chrismarlow — Sat, 23 Nov 2019 17:05:21 GMT

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.

Re: List Box and Straight table

Brett_Bleess — Thu, 05 Dec 2019 14:29:57 GMT

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