topic Silly question but really i cannot get the solution in QlikView

Silly question but really i cannot get the solution

Fri, 23 Mar 2012 15:15:37 GMT

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

Silly question but really i cannot get the solution

jvitantonio — Fri, 23 Mar 2012 15:20:36 GMT

Hi try removing '

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

Silly question but really i cannot get the solution

Fri, 23 Mar 2012 15:31:30 GMT

When the variable is null I get an error on the graph also withot '

Silly question but really i cannot get the solution

jvitantonio — Fri, 23 Mar 2012 15:33:32 GMT

ok, prueba asi:

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

Silly question but really i cannot get the solution

Fri, 23 Mar 2012 15:34:10 GMT

I get: Error in calculated dimension ....

Silly question but really i cannot get the solution

jvitantonio — Fri, 23 Mar 2012 15:35:34 GMT

But if the varible are not null, it works, right?

Silly question but really i cannot get the solution

Fri, 23 Mar 2012 15:36:05 GMT

Neither that solution ... I think the problem is not associated with the IF condition ... but with the field1 passed as dimension

Silly question but really i cannot get the solution

Fri, 23 Mar 2012 15:36:37 GMT

Yes the variable condition works

Re: Silly question but really i cannot get the solution

jvitantonio — Fri, 23 Mar 2012 15:39:15 GMT

so if you onlyu put this

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

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

,field1)

and the variables are not null, it works?

Silly question but really i cannot get the solution

sebastiandperei — Fri, 23 Mar 2012 15:40:40 GMT

Hi,

"Null" values are different to "Not Filled" vaules. You must consider both cases:

If (Max='' or Min='' or IsNull(Max) or IsNull(Min), field1....

Take in mind that this condition is only false when Max AND Min has a value...

Please, tell me if it works!!

Silly question but really i cannot get the solution

Fri, 23 Mar 2012 15:43:14 GMT

Yes it works with the normal expression

Silly question but really i cannot get the solution

jvitantonio — Fri, 23 Mar 2012 15:45:14 GMT

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

Silly question but really i cannot get the solution

sebastiandperei — Fri, 23 Mar 2012 17:38:23 GMT

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