Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

To show Relative Increment /decrement wrt to previous value.

Hi Everyone,

I m stuck with a problem to show relative increment and decrement of sales wen compared to previous year.

I have a table consisting 2 fields showing Year & sales values eg.

yearsales
1990100
199150
1992200
1993250
1994300
1995100

I am required to make a table or a chart( preferably chart) that must show values of  percentage increase or decrease in sales wen compared to just previous year starting frm 1991.

the prob is dat even thogh i have found out the corresponding values of inc/decr.using "  =sum(sales)/above ( total sum(sales)))* 100  "   but i have to show them in percentage inc /dec. ie, the decreasing amount should show -sign .Ii am stuck with, how to show the sign of decremented value

Is there any such method to show this in  a graph?? ..orr any method to plot negative values in graph..??.or atlest to show the result value with % sign alongwith.

thankx fr all generous response in advance.

3 Replies
Not applicable

Re: To show Relative Increment /decrement wrt to previous value.

Hi Alka,

I have used (Current Year Sale - Last Year Sale)/Current Year Sale to give you a view that you want to see.

Hope the file attached helps.

Regards

RL

Not applicable

Re: To show Relative Increment /decrement wrt to previous value.

Hi lakhina,

Thanks fr the helpful answer, but I had managed to solve it as it was required.

I had used" (sum(sales)-above(sum(sales)))/above(sum(sales)" and few design settings on graph.

This is providing me the required graph showing the percentage decrement and increment.( both + and -ve values plotted.)

:-)

kamalqlik
Valued Contributor

Re: To show Relative Increment /decrement wrt to previous value.

Hi Alka,

That will be shown as you will be having some negative value after the calculation will be made.

Regards

Kamal

Community Browser