topic Re: pivot table issue in QlikView

pivot table issue

Anonymous — Mon, 01 Dec 2014 16:58:40 GMT

Here in this pivot table..... i want performance total as (1*2)+(a*b) how can i write expression at performance....

Re: pivot table issue

JonnyPoole — Mon, 01 Dec 2014 18:14:36 GMT

Here is an example to get you started.

In this expression i could pick up the required total cells by using the dimensionality() function which returns 1's for the row grand totals. In that case i am adding 2 different row subtotals together using SET ANALYSIS. The grand total is a straight addition of the 2 percentages in the subtotals. You can do this with any valid arithmetic.

if( Dimensionality() <> 0 , sum(Sales)/sum(total Sales) ,

sum( {<Region={'North America'}>} total <Year> Sales) / sum (total Sales)

sum( {<Region={'Middle East'}>} total <Year> Sales) / sum (total Sales)

)

Re: pivot table issue

Anonymous — Tue, 02 Dec 2014 03:36:12 GMT

ya thank you very much .if there any issues i will ping u don't mine

please.

On Mon, Dec 1, 2014 at 10:15 PM, Jonathan Poole <qcwebmaster@qlikview.com>

Re: pivot table issue

Anonymous — Tue, 02 Dec 2014 03:50:00 GMT

Here in the performance tab it is like this check out.