Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot table problem

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.

1 Solution

Accepted Solutions
spividori
Valued Contributor

Re: Pivot table problem

Hi.

See the attachment. Hope this helps.

Regards.

4 Replies
MVP
MVP

Re: Pivot table problem

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

spividori
Valued Contributor

Re: Pivot table problem

Hi.

See the attachment. Hope this helps.

Regards.

Not applicable

Re: Pivot table problem

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.

spividori
Valued Contributor

Re: Pivot table problem

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.

Community Browser