topic Re: pb with the total displayed in QlikView

pb with the total displayed

master_student — Mon, 11 Jul 2016 18:43:08 GMT

Hi everyone,

I really need your help..

I am using a pivot table to show my data. The problem is whene I use the sum function, the amount displayed is not the same when selecting Total de l'expression / Somme de ligne. In my case the correcte amount is displayed when selecting total de l'expression but whene my users extract the table in an excel file and calculate the somme of the amount manually, they don't get the same result

here's my expression sum( POKTND)

I read that it would be better to use the aggr function like this :Sum ( Aggr( Sum({< $(vSetView)>} POKTND) , LB,Famille,CODE_PROJET,PO_FOURNISSEUR,PO_NUM_COMMANDE,PO_COMMENTS, PO_ACHETEUR,[Month of date], CDR) )

but the result is not correct.

any help please..it's urgent

Re: pb with the total displayed

vinieme12 — Mon, 11 Jul 2016 18:45:47 GMT

can you share a sample app or sample data?

Re: pb with the total displayed

master_student — Tue, 12 Jul 2016 08:17:26 GMT

Hi,

Thank you for your reply.

acctually it works with AGGR function :

Sum ( Aggr( Sum({< $(vSetView)>} POKTND) , LB,Famille,CODE_PROJET,PO_FOURNISSEUR,PO_NUM_COMMANDE,PO_COMMENTS, PO_ACHETEUR,[Month of date], CDR) )

but the problem is that I am using $(vSetView) to show MTD /YTD / Total year data , they change by the selection :

$(vSetView)=pick(ViewId,

'$(vSetMTD)',

'$(vSetYTD)',

'$(vSetTotal)')

View:

LOAD * INLINE [

ViewId, View

1, MTD

2, YTD

3, Total Year

];

any help so that my data change with the selection please?

Thanks