topic Re: Pivot table problem in QlikView

Pivot table problem

Mon, 28 Jan 2013 20:29:50 GMT

Hi there!

I've trying to use pivot table to show information between historical sales, but I use as dimension variable "year" and use dimension "weeks" on columns and expresion sum units sold.

So, I need to show differences per year on same week but I can found the best way but I cant to move this format, so just to use formulas to check this year divided on last year later.

Please give a little help with it.

Thanks a lot.

I attah .qvw file and screen to figured my request.

Re: Pivot table problem

Oleg_Troyansky — Mon, 28 Jan 2013 21:04:49 GMT

If you need to show Year over Year difference, I'd suggest not to use Year as a Dimension, but rather use individual expressions with Set Analysis Conditions for each Year:

Expression1: Current Year

Expression2: Prior Year

Expression 3 Change year over year.

cheers,

Oleg

Re: Pivot table problem

spividori — Mon, 28 Jan 2013 21:43:11 GMT

Hi.

See the attachment. Hope this helps.

Regards.

Re: Pivot table problem

Tue, 29 Jan 2013 11:25:06 GMT

Thanks a lot Sandro!!!!

Can I hide first column? I don't need it.

But second column use the first and answer mi question.

Thanks.

Re: Pivot table problem

spividori — Tue, 29 Jan 2013 11:53:24 GMT

Hi.

Exactly, the second column uses the first, is the way I solved it, I do not know if there will be another way to do it.

Regards.