Pivot table

[#1]

I have the Pivot table in Qlik Sense. I see the totals at the top. How do i make them to show up at the bottom?

[sunny_talwar]

Check this link: QS pivot table : How to get totals at the bottom?

[#3]

When I do it. It says invalid dimension

[#4]

Hi,

You can add Total as a dimension from your script. Then in the Pivot table, use ContryTotal as dimension

Test:

LOAD * INLINE [

Country, Value

A, 50

B, 60

C, 70

];

TotalTest:

Load

     Country as Country,

     Country as CountryTotal

resident Test;

concatenate (TotalTest)

Load

     Country  as Country,

     'Total' as CountryTotal

resident Test;

[#5]

Not sure how to adapt to my issue. This is what i have in the script. How do you suggest i change it?

LIB CONNECT TO 'Salesforce_BULK';

[pse__Expense__c]:

LOAD pse__Expense_Date__c,

  PSA_Approved_Date__c,

  PSA_Submitted_Date__c,

    pse__Expense_Report__c,

    pse__Amount__c,

    pse__exchange_rate_Incurred_currency__c;

SELECT  pse__Expense_Date__c,

  PSA_Approved_Date__c,

  PSA_Submitted_Date__c,

    pse__Expense_Report__c,

    pse__Amount__c,

    pse__exchange_rate_Incurred_currency__c   

FROM pse__Expense__c;

[#6]

Can you please let me know which field to use as a dimension? then create a new table using that field like i did (in my case is a country field). Also you need to consider sorting order so the Total can stay at the bottom. You might need to add a new column for sorting.

[#7]

The count of this field "pse__Expense_Report__c", is used for calculating totals

[#8]

Note: this is for Dimension, not the measure.

So basically you add a Total dimension to the existing dimension

ExpenseReportTotal:

Load

pse__Expense_Report__c as pse__Expense_Report__c,

pse__Expense_Report__c as pse_Expense_Report_Total

resident pse__Expense__c;

concatenate (ExpenseReportTotal)

Load

pse__Expense_Report__c as pse__Expense_Report__c,

'Total' as pse_Expense_Report_Total

resident pse__Expense__c;

[#9]

Thanks. I will try it

[#10]

Hi,

I have the same issue but with months as a dimension. In my case it doesn't make sense to add a total as a dimension because it will always show me the total for all the months I have in DB.

Do you know of any possible solution for my case?

Thanks!