Use a variable inside a list box expression ?

[#1]

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!

[sunny_talwar · Accepted solution]

Try this:

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

[#3]

Thanks! it worked perfect!!

[sunny_talwar]

Great -

Please close the thread by marking the correct answer.

Qlik Community Tip: Marking Replies as Correct or Helpful