Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

omnomnom
New Contributor

Pivot calculation

Hi i have Excel table like this

SupplSubCategory
Category1201210 627  144 423 
201311 284  130 380 
6%-10%
Category2201210 627  565 008 
201311 284  549 901 
6%-3%

How can i make it in qlikview?

Tags (1)
1 Solution

Accepted Solutions

Re: Re: Pivot calculation

Siarhei

Have a look at the attached.

Best Regards,    Bill

8 Replies
omnomnom
New Contributor

Re: Pivot calculation

Dropbox - xls.xls

xls for better understanding

giakoum
Honored Contributor II

Re: Pivot calculation

you can load the data without the % in QlikView and create the % difference as a column instead of a row.

omnomnom
New Contributor

Re: Pivot calculation

Hi, im already have pivot table

but im dont know how to add 2013/2014 diffirence to red line place

3mki3zr.png

omnomnom
New Contributor

Re: Pivot calculation

this is result what i want to get/

R1EOkSJ.png

giakoum
Honored Contributor II

Re: Pivot calculation

the only way to achieve that is to create the rows in your data model while reloading. Otherwise I don't think it is possible.

Not applicable

Re: Pivot calculation

Check out the Dimensionality() function in the help page of QlikViw. It will help you.

Re: Re: Pivot calculation

Siarhei

Have a look at the attached.

Best Regards,    Bill

omnomnom
New Contributor

Re: Pivot calculation

wow! big thanks!

Community Browser