I am back again with another question to you. In fact, I have been working yesterday on pivot tables. However, I don't know if it is possible to use pivot tables as datasource in order to use it in other charts and objects.
No, all charts in qlikview use the internal in-memory database as data source. Charts cannot reference data that is calculated in other charts. It is possible to put the chart expressions in variables and use the variable in several charts. That way it is possible to reuse the expressions in more than one object.
In order to user your pivot chart or any data source you will need to bring in QlikView in-memory data model. You may need to enable the transformation while loading and then you have to plot again in QlikView UI.
If you are loading any crosstable or xls where you need only particulare data in particular fashion, you'll need to go for transformation step where you can edit or delete the rows and colums and many more.
