Total qv

[master_student]

Hi ,

My pb is that the total displayed in Qlikview is different from the one after excel extarct.

My expression is:

sum( {< $(vSetView)>} POKTND)

with : $(vSetView)

=pick(ViewId,

'$(vSetMTD)',

'$(vSetYTD)',

'$(vSetTotal)')

so that the values of my measures change with the selection : MTD/YTD/Total year

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

The result is : it does taking into account the selection YTD and the total of June is not correct :

I would like the result to be a pivot table with total measures= extract excel

Any help please.

Thanks

[swuehl]

It's hard to answer these kind of questions without actually being able to see the data model and values.

In general, you might need to apply the set expression also to the outer aggregation function:

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

Set Analysis in the Aggr function

[master_student]

Thanks for your reply,

I get error in expression when I did as you recommended.

[Digvijay_Singh]

Can you share complete expression behind  $(vSetView), not able to see left part before equal sign of the set modifier  like {<Field = {Element list}>}

[master_student]

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

$(vSetView) is a varialble to display the MTD/YTD/Total years values