Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Pivot table

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?

11 Replies

Re: Pivot table

Not applicable

Re: Pivot table

When I do it. It says invalid dimension

2016-06-13_15h58_46.png

Not applicable

Re: Pivot table

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;

Not applicable

Re: Pivot table

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;

Not applicable

Re: Pivot table

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.

Not applicable

Re: Pivot table

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

Not applicable

Re: Pivot table

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;

Not applicable

Re: Pivot table

Thanks. I will try it

Not applicable

Re: Pivot table

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!

Community Browser