Total mode

[master_student]

Hello everyone,

Who can explain to me the difference between Total de l'expression /somme de lignes

and why the Totaux tab is disabled when using pivot Tables?

Thanks a lot

[trdandamudi]

Please look into the below link:

https://community.qlikview.com/thread/56468

[migueldelval]

Hi master student,

The difference is:

     A) Total de l'expression= Sum always

     B) somme de lignes= mathematical expression, eg: media.

Regards

Miguel del Valle

[ciaran_mcgowan]

If you use the SUM() in the expression, then Expression Total mean the same thing (except when ratios are involved but you can look at Thirumala's post for more info).

The drop down is typically used when you don't use a function to return an expression (e.g. returning 'POKTND' instead of 'SUM(POKTND)') and you want to use the list to preform your math functions. Most users would just write that into the expression itself though (like you are doing) so I would continue to do that.

As for the pivot tables, these functions are disabled because you must use the 'Show Partial Sums' checkbox in the Presentation tab. I'm not sure why they grey it out in the Expressions tab instead of hiding it.

[#5]

Pivot table total can be enabled by selecting "Show Partial Sums" in the presentation tab of the properties.

[Anil_Babu_Samineni]

Can you please share me the Sample App. So that, We can look

[master_student]

Hi , Here is my expression :

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