topic Re: Expression for my chart in QlikView

Expression for my chart

Anonymous — Tue, 27 May 2014 18:24:26 GMT

Good afternoon gentlemen,

I'm here with some more questions.

I need to put an expression in my chart table that confront the values of revenues in the previous month and the next month, and show me the value in%.

Attached is a picture explaining better.

I hope I have managed to get through my doubt.

Who can help me, thank you.

hugs

Re: Expression for my chart

Tue, 27 May 2014 19:43:16 GMT

You want to compare the revenue between two months?

Depending on how you have things set up, there are a few options.

A little more context would be helpful though, could you share a little more?

Re: Expression for my chart

MarcoWedel — Tue, 27 May 2014 21:18:07 GMT

Hi Matheus,

one way would be like this:

=Num((amount-Below(amount))/Below(amount)*100, '0.00')

example qvw attached:

hope this helps

regards

Marco

Re: Expression for my chart

Anonymous — Wed, 28 May 2014 13:59:14 GMT

Hi Marco,

Thanks for writing, I tried to run the expression above and did not work.

I'll try to explain it better.

The data in the field "amount" values are not fixed, they are the results of the expression = sum (VL_TOTAL_NF_SAIDA).

Look at my qvw file:

Thanks for the help !

Matheus

Re: Expression for my chart

PradeepReddy — Wed, 28 May 2014 14:20:46 GMT

try the expression like this....

num((sum(VL_TOTAL_NF_SAIDA)-Below(sum(VL_TOTAL_NF_SAIDA)))/Below(sum(VL_TOTAL_NF_SAIDA))*100, '0.00')

Re: Expression for my chart

Anonymous — Wed, 28 May 2014 14:41:29 GMT

Wow !

Now it worked !

Thanks !

Re: Expression for my chart

MarcoWedel — Wed, 28 May 2014 15:10:32 GMT

sorry that my answer wasn't helpful.

regards

Marco

Re: Expression for my chart

Anonymous — Wed, 28 May 2014 15:13:49 GMT

Marco,

Thanks for trying to help me.

Again thank you.

Re: Expression for my chart

MarcoWedel — Wed, 28 May 2014 15:22:20 GMT

you're welcome

regards

Marco