topic Re: button ranging values in QlikView

button ranging values

Fri, 11 Sep 2015 06:12:58 GMT

I need a button, if i click on button , SalMonth values of Jan,feb,Mar,apr,May should get selected

if i clear then teh SalMonth filter should have no selections

please do not hardcode the values.

please suggest me on this

Re: button ranging values

tresB — Fri, 11 Sep 2015 06:21:08 GMT

Search string: (Jan|Feb|Mar|Apr|May)

PFA

Ohh, you wrote not to hard code. Then what is your logic ? First five months?

If, so, you could try search string like: ='('&Concat(If(Month(Date#(SalMonth,'MMM'))<=5,SalMonth),'|')&')'

Re: button ranging values

Fri, 11 Sep 2015 06:28:55 GMT

Thanks Tresesco for the response

I need a logic like --> values in the list box should have numbers like 1,2,3,4,5,6,7 along with the data.

then based on the values it should take the selections

some thing like, Index,pick or firstsortedvalue which give the number for the values.

Re: button ranging values

tresB — Fri, 11 Sep 2015 06:30:41 GMT

Even that listbox numbers would not be required, please check above the updated comment and app. And if you insists of that numeric filed use, try search string like:

='('&Concat(If(Eid<=5,SalMonth), '|')&')'