topic Re: Including fuzzy search on selection in QlikView

Including fuzzy search on selection

Wed, 25 Nov 2020 16:16:04 GMT

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.

sunny_talwar — Mon, 29 Aug 2016 10:47:12 GMT

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

Anonymous — Mon, 29 Aug 2016 10:55:28 GMT

may be try this in text box expression?

=GetFieldSelections(zemail ,'; ')

Mon, 29 Aug 2016 11:18:11 GMT

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 — Mon, 29 Aug 2016 12:19:26 GMT

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

tresB — Mon, 29 Aug 2016 12:30:10 GMT

May be like:

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

Mon, 29 Aug 2016 12:47:44 GMT

Thanks, that helped!

Regards,

Prajna