Silly question but really i cannot get the solution

[#1]

I want to make a calculated dimension based on a value of a variable:

If the value of the variable is null or is not filled I want the normal field and if the variable as a value a want the calculated dimension:

I tried with this :

=if('$(Max)'='' or '$(Min)'='',field1,

if(aggr(sum(W_etc)/SUM(W_etc2),field1)>=$(Min)

and aggr(sum(W_etc)/SUM(W_etc2),field1)<=$(Max)

,field1)

)

What's wrong? Why I get an error if max or min are empty or null ?

Thanks in advance

[#2]

Yes it works  with the normal expression

[jvitantonio]

Then try what sebastian said and try changing OR with AND and make both variable null. Otherwise, post your application.

[sebastiandperei]

If it works... why don't you mark as Answered, to qlikuser14 or me?