topic week compare in QlikView

week compare

Anonymous — Thu, 14 Jun 2012 08:42:24 GMT

Dear ALL,

Please find the attached xl sheet, in this we have the data for all weeks from '1/30' to '6/11' we compare the value of every comming week with startweek value ie by using the formule eg:(week6/11value /week1/30 -1) in xl sheet and convert it into percentage.Please suggest an expression.

Re: week compare

christophebrault — Thu, 14 Jun 2012 09:32:19 GMT

Hi,

I attached an example from your data, but i have a licenced edition.

Step to step :

Create a pivot table chart with Date as dimension and others if you want.

Set Date dimension horizontaly in the graph.

Create an expresssion sum(Value) to show the sum for the Date.

Create a second one : sum(Value)/before(sum(Value),columnno()-1,1)-1 and set in % in number

This chart will adapt automaticaly to your time selection.

Re: week compare

Anonymous — Fri, 15 Jun 2012 06:41:10 GMT

hi Christophebrault

Thanks for correct replay,it is what i am looking in the abow file.

Thanks

arunreddy

Re: week compare

Anonymous — Thu, 19 Jul 2012 05:28:06 GMT

Hi Christophebrault,

Is it posible to bring the same values in line chart,how to calculate the

values for before(sum(Value),columnno()-1,1)-1 in line chart.

ie : sum(Value)/before(sum(Value),columnno()-1,1)-1 and set in % in number

Thanks

arunreddy