total mode

[ssriramin19]

Hello,

The total mode in expression tab has been disabled. I am using qlikview 11 version . How to enable the total mode in the expression tab?

Thanks

Sriram

[robert_mika]

Because this is the way it is.

Not all option are available for all chart types.

Total in exporession is only available for  PT

[morganaaron]

Hi Sriram,

You can't have an expression total for a bar chart - it has to be done at the dimension limits level. What is it you're trying to do? There are workarounds using aggr() for things like averaging if that's what you need.

[ssriramin19]

is this option total mode not available in version 11. We are migrating our dashboards from 9 to 11. In version 9 it was available but in version 11 I found total mode is disabled.

But with the dimension limits I could able to achieve the requirement .Just a clarification between 9 and 11 is needed now .Please help on this

[morganaaron]

It's not available in bar charts in v11 or 11.2, no. It will be for other types of chart (as Robert mentioned, straight tables for example).

[ssriramin19]

Clarify again .The option is not available in 11. Right ? Just checking again . I need to document these.

[morganaaron · Accepted solution]

It's not available in 11.

[ssriramin19]

Thanks Aaron for clarifications- Was very useful

[#9]

Hi sriram,

Could you please mark as my answer as helpful.

Thanks

Avinash

[ssriramin19]

I have marked both useful and correct answer. Timely help .