topic SUM OF ROWS INSTEAD OF EXPRESSION TOTAL IN PIVOT TABLE in QlikView

SUM OF ROWS INSTEAD OF EXPRESSION TOTAL IN PIVOT TABLE

Wed, 19 May 2010 15:50:55 GMT

Ciao to everybody,

I have a problem. I have a pivot table with some dimensions and some expressions.

The dimension [Pos Tg]=valuelist('01',....,'15','Tot').

Expressions Reale and Ordini are two sums.

Expression + is equal to Ordini-Reale only if Ordini-Reale>0 (that is if(column(2)-column(1)>0,column(2)-column(1)))

Expression - is equal to Ordini-Reale only if Ordini-Reale<0 (that is if(column(2)-column(1)<0,column(2)-column(1)))

On the total line a would like to have expressions + and -as the sums of the rows instead of expression total.

So on the total row for + and - expressions I would like to have the following situation:

Could someone help me??? I've tried all possible aggregation functions available!!!

Many thanks to everybody.

SUM OF ROWS INSTEAD OF EXPRESSION TOTAL IN PIVOT TABLE

Wed, 19 May 2010 18:47:59 GMT

Hi Elena?

Might be my age but - beside the repeated listing of Offer and Codice in table 2 - I do not see a difference between your 2 tables?

Regards

Juerg

SUM OF ROWS INSTEAD OF EXPRESSION TOTAL IN PIVOT TABLE

Thu, 20 May 2010 07:20:11 GMT

Dear Juerg,

the differences between the two tables are on the totals on the last two lines (in the second one I write myself the numbers I would like to have...)

I hope now my problem is clearer.

SUM OF ROWS INSTEAD OF EXPRESSION TOTAL IN PIVOT TABLE

Thu, 20 May 2010 08:22:55 GMT

Hi Elena

OK, saw it now. Sorry but am not aware that you can have a different formula in the total than in the details or that we have a queriable flag when being in the total row.

Regards

Juerg

P.S. where do we go for vacation now - beach or mountains?

SUM OF ROWS INSTEAD OF EXPRESSION TOTAL IN PIVOT TABLE

Thu, 20 May 2010 08:56:12 GMT

Thanks for your answer.

Always mountains: the beautiful Dolomites!