Custom totals in Qlik Sense tables

[arturomiquelveyrat]

Question

How to use custom formulas for totals rows/columns in Qlik Sense tables. This works for both straight and pivot tables.

 Custom colum       Custom row

 Answer 

Check the option to display totals for the desired dimension (in pivot tables) or measure (in straight tables).

For a custom totals row, use:

If(Dimensionality() = 1,
    123,    // Expression for regular rows
    999     // Expression for totals
)

For a custom totals column, use (only in pivot tables):

If(SecondaryDimensionality() = 1,
    123,    // Expression for regular columns
    999     // Expression for totals
)

[anushree1]

Will this work with Valuelist conditions and Column(1)-Column(2) kind of expressions when calculating the Totals(Dimensionality being 0).

It does not seem to work in both cases for me

[emmyfreed24]

There are two methods through which you can easily connect MongoDB in QLik

1.  through Qlik Sense, you connect to a MongoDB database through the Add data dialog or the Data load editor.
2. And, QlikView you connect to a MongoDB database through the Edit Script dialog.

You will need to know the server and database name that you want to connect to, and you must have access credentials. Once you have created a wireclub connection to a MongoDB database, you can select data from the available tables and then load that data into your app or document.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Mongo/...