topic Re: Total mode in QlikView

Total mode

master_student — Mon, 20 Jun 2016 12:53:04 GMT

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

Re: Total mode

trdandamudi — Mon, 20 Jun 2016 12:56:44 GMT

Please look into the below link:

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

Re: Total mode

migueldelval — Mon, 20 Jun 2016 13:33:46 GMT

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

Re: Total mode

ciaran_mcgowan — Mon, 20 Jun 2016 13:49:33 GMT

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.

Re: Total mode

Mon, 20 Jun 2016 14:01:22 GMT

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

Re: Total mode

Anil_Babu_Samineni — Mon, 20 Jun 2016 14:07:17 GMT

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

Re: Total mode

master_student — Tue, 21 Jun 2016 08:33:34 GMT

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