topic Re: Use a variable inside a list box expression ? in QlikView

Use a variable inside a list box expression ?

Tue, 17 May 2016 10:01:01 GMT

Hi, I cant find a solution for this, I have a week Selector with numeric values (201601,201602,etc)

I want to limit the weeks with a variable that I have created: Max(Customer_week) that variable is working fine, cos I put it on a text field and it works perfectly and shows the correct value.

Now in my week selector, instead of assign the week field, I put this expression:

=if(weekT<=Max(Customer_week),weekT)

with that line, nothing happens and the selector is blank, If I just change for testing purpose the line to:

=if(weekT<=201610,weekT)

It works!

I dont know where is my error

I appreciate your help

thanks in advance!

Re: Use a variable inside a list box expression ?

sunny_talwar — Tue, 17 May 2016 16:40:26 GMT

Try this:

=If(weekT<=Max(TOTAL Customer_week), weekT)

Re: Use a variable inside a list box expression ?

Tue, 17 May 2016 16:51:00 GMT

Thanks! it worked perfect!!

Re: Use a variable inside a list box expression ?

sunny_talwar — Tue, 17 May 2016 17:07:50 GMT

Great -

Please close the thread by marking the correct answer.

Qlik Community Tip: Marking Replies as Correct or Helpful