topic Re: Reduce a chart value to base 100 ..% in QlikView

Reduce a chart value to base 100 ..%

Anonymous — Thu, 08 Oct 2015 16:16:58 GMT

Hi all,

I need help to create a chart to compare the growth and decrease in % from the price value.

See the picture...

I have the first chart but i want the second chart...

Mar = 0;

Comprare:

Apr with Mar;

May with Mar;

Jun wuth Mar;

Can u help me?

Tanks.

Regards,

robert_mika — Thu, 08 Oct 2015 20:06:45 GMT

So you need the bottom chart in QV?

Could you post your app?

Anonymous — Fri, 09 Oct 2015 15:09:59 GMT

Hi Robert,

I don't understand what you mean with 'bottom chart'.

I don't need the chart with the absolute value Price. I need the comparison (%) the prices of months with the first month 'Mar'.

Let me explain:

In 'Mar' i have 0%

In 'Feb' the price growth 1,5% (comparison of 'Mar')

In 'Apr' the price growth 0,75% (comparison of 'Mar')

...

In excel the calculation is:

For Mar ---- (Mar-Mar)/Mar) = 0%

For Feb ---- (Feb-Mar/Mar) = +/-X%

Variation% = (Vn-V0)/V0

...

I fix the value price for Mar, because is comparative value.

Thank in advance.

Regards,

Pedro Lopes