List Box Expressions and Search Abilities

Wed, 11 Feb 2015 16:41:11 GMT

All,

I created an expression within my "YEAR" listbox that says if(YEAR>=2012, YEAR) - this works and still allows me to use the search icon as needed. When i created a similar expression within a SERIES listbox that says if(sum(NETSALES>0,SERIES,SERIES) - it would not work if i only had 1 SERIES like the first formula. Whenever i tried to initially search within series using the search icon, it would not allow me to until i changed over to "wildcard" setttings. Now it will not allow me to "select Excluded" - any ideas?

thanks for your help,

Parrish

Re: List Box Expressions and Search Abilities

alexandros17 — Wed, 11 Feb 2015 16:45:16 GMT

If you use expressions (like yours) in the list box "select Excluded" will not be allowed, besides, that expession cannot work,

try, in the script to set a flag where Netsales > 0 for each row than use that flag in your above expresison

topic Re: List Box Expressions and Search Abilities in QlikView

List Box Expressions and Search Abilities

Re: List Box Expressions and Search Abilities