topic Optimizing the search box using qualify fields in QlikView

Optimizing the search box using qualify fields

vikasmahajan — Wed, 02 Dec 2015 10:20:33 GMT

tgh

settu_periasamy — Wed, 02 Dec 2015 14:19:58 GMT

Hi Vikas,

I think it will work, Could you Please post the sample data? Let us try it..

vikasmahajan — Thu, 03 Dec 2015 04:00:58 GMT

Thanks Settu I post sample please give some time

Thanks

Vikas

vikasmahajan — Thu, 03 Dec 2015 04:31:38 GMT

PFA Sample data

Vikas

settu_periasamy — Thu, 03 Dec 2015 04:50:27 GMT

Hi Vikas,

I think it is working for me. Can you check the attachment..

Note: We need to select atleast one table

vikasmahajan — Thu, 03 Dec 2015 04:52:19 GMT

Thanks Settu

tresB — Thu, 03 Dec 2015 04:58:43 GMT

Try list of fields - expression like:

=Concat(IF(WildMatch($Field, '*'& %Initative &'*'), $Field), ',')

You might want to deal the cases separately when nothing/multiple values are selected.

vikasmahajan — Fri, 18 Dec 2015 05:07:34 GMT

TableN:

Load inline [

TableName

Abc*

PQR*

XYZ*

];

=TableName&';Region;Country Name;CIO Group;CTO Group'

This way it is sorted thanks

Vikas