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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Including fuzzy search on selection

Hi,

I would like to filter data based on selected string value.

ex: I have fields email  and zemail.

On selected email =CCmark I can see two fields related in zemail like CCmark,NPCargo.

So I want a text box selected on selection of data having zemail= CCmark when I click email =CCmark .I tried wildmatch but it didn't work.

Can anyone suggest  me a better approach.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like:

=if(max(if (Email= z_Email,1,0))=1 and sum(Actuals)>0,1,0)

View solution in original post

6 Replies
sunny_talwar

Not sure I understand what you are doing, would you be able to elaborate? and provide a sample may be?

Anonymous
Not applicable
Author

may be try this in text box expression?

=GetFieldSelections(zemail ,'; ')

Not applicable
Author

What I am trying to do is , I am making a conditional display of a text box object.

In layout I have mentioned

=if(GetFieldSelections(Email)= z_Email and sum(Actuals)>0,1,0)

The prob what am facing here is zemail is giving two values but I want the wont that matches with email alone.

Hope this helps!

Thanks,

Prajna

sunny_talwar

Email include two values of z-Email? I am still not sure I understand, would you be able to provide a sample?

tresesco
MVP
MVP

May be like:

=if(max(if (Email= z_Email,1,0))=1 and sum(Actuals)>0,1,0)

Not applicable
Author

Thanks, that helped!

Regards,

Prajna