Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
santhoshkasam09
New Contributor III

Customisation of the Totals in a chart

Hi all,

I have a requirement where the totals of the chart is not usual. In a pivot table, based on the column value, the total display should change.

Is there any way to achieve this? Thank you.

Regards

Santhosh Kasam

1 Solution

Accepted Solutions
jaumecf23
Contributor III

Re: Customisation of the Totals in a chart

You can use the Dimensionality() function. Here you have more information:

How to use - Dimensionality()

4 Replies
jmvilaplanap
Valued Contributor

Re: Customisation of the Totals in a chart

Hi,

Could you explain better your question? I don´t understand what are you trying to say.

Regards.

jaumecf23
Contributor III

Re: Customisation of the Totals in a chart

You can use the Dimensionality() function. Here you have more information:

How to use - Dimensionality()

santhoshkasam09
New Contributor III

Re: Customisation of the Totals in a chart

Hi Jose,

For example, I am trying to display orders, backlog, etc in the pivot table which belong to one column. Under that I have to show the current year and prior year count. Now the total formula for Orders is different from the Backlog.

I want to customise the formula only for totals. Let me know in case you need anything else. Thank you

Regards

Santhosh Kasam

santhoshkasam09
New Contributor III

Re: Customisation of the Totals in a chart

Hi Jaume,

This worked. Thanks for your response

Regards

Santhosh Kasam

Community Browser