Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Kunkulis
Creator
Creator

List Box and Straight table

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')

 

Labels (3)
2 Replies
chrismarlow
Specialist
Specialist

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.

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.