topic Re:Pivot table problem in QlikView

Pivot table problem

Wed, 22 Dec 2010 17:48:51 GMT

Hi all,

I've a problem with a pivot table. I've two variables (sales and salesLY), one for the sales of current selection and other for the sales of the last year (year selected - 1). With this data, i extract the variation of sales (formula: (sales-salesLY) / salesLY).

The data is correct but in the table, when i apply the filter 'oct-2010', it show 'oct-2010' and 'oct-2009'. What can i do to not have 'oct-2009' in the table? If i remove the variation column, 'oct-2009' does not appear.

Sales: Sum({<CONCEPTO={8600}>} Value)

Sales LY: Sum({<YEAR={$(=YEAR-1)},CONCEPTO={8600}>} Value)

Thanks!

P.D. Excuse my bad english, 😞

Pivot table problem

Wed, 22 Dec 2010 19:58:03 GMT

do you want to show only de column with the formula?

Re:Pivot table problem

Thu, 23 Dec 2010 14:00:50 GMT

Hi Raul,

Thanks for your interest. I want to show the column with the sales amount and the column with the variation.

Here's a snapshot of the pivot table i've now. As you can see, i've filtered year=2010 but there's a row with the data for year=2009.

Re:Pivot table problem

Thu, 23 Dec 2010 14:30:47 GMT

I think it is very reasonable this column is in your Pivot. What you want to achieve is not logical.

Ik you select Year 2009 the column will contain the result for 2008, because you have your variable to year-1

so you have to look again what you want to achieve !

AW:Pivot table problem

martinpohl — Thu, 23 Dec 2010 14:31:08 GMT

Hello,

your formula is

Sales LY: Sum({<YEAR={$(=YEAR-1)},CONCEPTO={8600}>} Value)

YEAR=YEAR-1 so if you select 2010 you calculate (2010-1)=2009

Or am I wrong?

Regards

Re:Pivot table problem

Thu, 23 Dec 2010 17:40:42 GMT

Thanks for your answer Jochem & wise man.

Jochem:

What i want to achieve is, for a selected year, the sales by months (for the selected year, not the selected year and last year) and the growth over the same period last year.

wise man:

You're right, i've to calculate the sales of the last year to see the variation.

Thanks again.