topic Re: Change percent between years in QlikView

Change percent between years

QSense — Tue, 11 Dec 2012 08:31:01 GMT

Hello

I have an expression shows historical data

and expression is :

Sum ({$<Servisler= {'Circuits'} >}Tutar) + Sum ({$<Servisler= {'CUTE (MDNS)'} >}Tutar) + Sum ({$<Servisler= {'IP VPN'} >}Tutar) + Sum ({$<Servisler= {'Managed Data Network Services'} >}Tutar)

+ Sum ({$<Servisler= {'Type B Services'} >}Tutar)

How can I make a line shows percentage of changes between years?

Re: Change percent between years

Tue, 11 Dec 2012 09:01:01 GMT

pls refer the attached file, I hope , This helps u.

Regards,

Kabilan K.

Re: Change percent between years

QSense — Tue, 11 Dec 2012 09:21:23 GMT

In my chart, There must be two expression one of them must be bar and other should be line

line should show changes between years as percent

I attach my example in SITA tab on the right side you will see chart

I put the changes percent in text box and they are on chart

Re: Change percent between years

Tue, 11 Dec 2012 10:31:04 GMT

Hi,

change chart type as Combo chart.

and Add this as ur 2nd expr on your chart, column(1)/above(column(1))-1

and go to Axes tab- > select the 2nd expr and select right option in the position.

then go to number tab -> select the 2nd expr and select Fixed to as well as check the show in percent check box.

I Hope it will help You.....

Re: Change percent between years

QSense — Tue, 11 Dec 2012 11:36:50 GMT

Thanks ,

How can I show negative values above zero not under zero?

Re: Change percent between years

Tue, 11 Dec 2012 12:14:24 GMT

try Split axes option in the axes tab..