topic Dynamic and compressed filter selection in QlikView

Dynamic and compressed filter selection

nareshthavidishetty — Wed, 02 Mar 2016 06:33:18 GMT

Hi,

Am having a list box as below,

A,1,2,r,y,……

A,6,s,7,d,…..

B,e,46y,5,d,h,….

B,e,3,S,7,10,…..

Actually my list box looks like this, but here my requirement is my listbox should contains only two values as ,

Here if I select category ‘A’ means it should show what all the filters start with ‘A’ should come in report but my filter should contains only

'A'&'B'

Thanks..

MarcoWedel — Wed, 02 Mar 2016 06:41:12 GMT

Use this expression in the listbox field selection:

=Left(category,1)

Regards

Marco

arulsettu — Wed, 02 Mar 2016 06:42:24 GMT

may be like this in list box expression

=if(WildMatch(yourfield,'*A*'),'A',

if(WildMatch(yourfield,'*B*'),'B',))

or this

=SubField(yourfield,',',1)

avinashelite — Wed, 02 Mar 2016 06:43:37 GMT

try like the below expression in the list box

subfield(filedname,',',1)