topic Re: Problem with a variable in QlikView

Problem with a variable

Wed, 17 Oct 2012 15:43:58 GMT

Hi everyone,

I'm in trouble using a variable on my designe.

I built a pivot table and I have to insert my expression.

the expression is:

if( $(vUtPe) >= 0

$(vUtPe)

)

where $(vUtPe) is:

sum({ $<D_LIV1={BITI},D_LIV2={ATTIVO},Partite.Anno={ 2012}> } Partite.WRBTR)

sum({ $<D_LIV1={BITI},D_LIV2={PASSIVO},Partite.Anno={ 2012}> } Partite.WRBTR)

unfortunately it doesn't show me the result. I mean the test say OK is >0 but I don't have the result on my row. To be clearer it doesn't show me that records.

If I write:

if( $(vUtPe) >= 0

'OK >0'

)

it works. I have the row with " Ok > 0 ".

I don't understand what is going on.

The if test is working but when i try to put the variable as result it doesn't work.

Any help will be appreciated

thanks in advance

Giampiero

Re: Problem with a variable

Wed, 17 Oct 2012 15:48:28 GMT

Hi,

try to add equal sign in expression of variable $(vUtPe)

=sum({ $<D_LIV1={BITI},D_LIV2={ATTIVO},Partite.Anno={ 2012}> } Partite.WRBTR)

sum({ $<D_LIV1={BITI},D_LIV2={PASSIVO},Partite.Anno={ 2012}> } Partite.WRBTR)

Regards

Re: Problem with a variable

Thu, 18 Oct 2012 07:31:52 GMT

Hi Mario,

thanks for your reply.

I tried, but it doesn't work.

Thank you

Giampiero

Re: Problem with a variable

Thu, 18 Oct 2012 08:02:25 GMT

Hi,

i dnt understand from where OK comes into the if expression in place of the variables ?

Could u explain?

Regards

Re: Problem with a variable

kouroshkarimi — Thu, 18 Oct 2012 08:06:59 GMT

Maybe try experimenting without the dollar sign expansion, or by putting the variable in single quotes.

Re: Problem with a variable

Thu, 18 Oct 2012 08:14:29 GMT

Hi,

what I want to say is. The test of the if is working. So

if( $(vUtPe) >= 0

Test works fine. So it goes on and i can put my var here. unfortunately whene i put $(vUtPe) here, it doesn't work. But if I put a string like "I TEST POSITIVE" it works.

)

hope it helps.

THANKS A LOT for your reply

Re: Problem with a variable

Thu, 18 Oct 2012 08:16:14 GMT

Hi,

I tried both solutions.

Unfortunately they don't work.

Many thanks

Re: Problem with a variable

miikkaqlick — Thu, 18 Oct 2012 08:49:50 GMT

Hi!

First I would try writing your expression like this:

if( $(vUtPe) >= 0

$(=vUtPe)

)

There is that extra equal-sign.

Then I would try creating textbox with expression =$(=vUtPe)and see what it gives.

Then I would replace vUtPe in original expression with new variable (lets say LET A = '1';)

Last I would place that original variable vUtPe to table as an expression, without label, and check how dollar sign expansion is working.

In this point you know where the problem is and you can solve it.

BR,

Miikka

Re: Problem with a variable

Thu, 18 Oct 2012 09:10:04 GMT

Hi Miikka,

Thanks for your reply.

I tried but it doesn't work.

Fortunately , i understood why it doesn't show the variable.

It's my fault because I ever have to think about how Qlik works.

I wanted to put a general result on a row so in a particular result.

obviously it was a mistake.

So it was sufficient to write my var with tis expression:

sum( TOTAL { $<D_LIV1={BITI},D_LIV2={ATTIVO},Partite.Anno={ 2012}> } Partite.WRBTR)

sum( TOTAL { $<D_LIV1={BITI},D_LIV2={PASSIVO},Partite.Anno={ 2012}> } Partite.WRBTR)

adding "TOTAL" in my expression I resolved my problem.

THANK YOU so much to everybody.

This community is fantastic for all of us.

Bye

Giampiero

Re: Problem with a variable

jonathandienst — Thu, 18 Oct 2012 09:32:23 GMT

Rather than using an If statement here, which requires the expression to be evaluated twice, I would suggest using RangeMax, like this:

= RangeMax(0, ($(vUtPe)))

That should return the expression variable value if it is greater than 0, or 0 if less than zero.

Hope that helps

Jonathan

Re: Problem with a variable

Thu, 18 Oct 2012 09:48:23 GMT

Hi Jonathan,

THANK YOU so much.

It's a very good idea.

I like it a lot.

Thanks

Giampiero

Re: Problem with a variable

Thu, 18 Oct 2012 09:56:54 GMT

instead of this

if( $(vUtPe) >= 0

$(=vUtPe)

)

try that:

if( vUtPe >= 0, vUtPe,0)

regards,

Re: Problem with a variable

Thu, 18 Oct 2012 10:30:07 GMT

Thank you,

good advise.