topic Total qv in QlikView

Total qv

master_student — Wed, 22 Jun 2016 07:55:38 GMT

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

Re: Total qv

swuehl — Wed, 22 Jun 2016 21:38:56 GMT

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

Re: Total qv

master_student — Thu, 23 Jun 2016 10:32:43 GMT

Thanks for your reply,

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

Re: Total qv

Digvijay_Singh — Thu, 23 Jun 2016 10:45:29 GMT

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

Re: Total qv

master_student — Thu, 23 Jun 2016 11:11:08 GMT

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