Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have Excel table like this
Suppl | SubCategory | ||
Category1 | 2012 | 10 627 | 144 423 |
2013 | 11 284 | 130 380 | |
6% | -10% | ||
Category2 | 2012 | 10 627 | 565 008 |
2013 | 11 284 | 549 901 | |
6% | -3% |
How can i make it in qlikview?
xls for better understanding
you can load the data without the % in QlikView and create the % difference as a column instead of a row.
Hi, im already have pivot table
but im dont know how to add 2013/2014 diffirence to red line place
this is result what i want to get/
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.
Check out the Dimensionality() function in the help page of QlikViw. It will help you.
Siarhei
Have a look at the attached.
Best Regards, Bill
wow! big thanks!