Hi i have Excel table like this
How can i make it in qlikview?
Dropbox - xls.xls
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.
Have a look at the attached.
Best Regards, Bill
wow! big thanks!
Retrieving data ...