Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alignment Issue for Secondary Dimension Total Values

Is there an easy way to align the values for Secondary Dimension totals in a bar chart? I attached an example of what Im trying to do. Thanks.

Labels (1)
2 Replies
Clever_Anjos
Employee
Employee

One trick is mark only one expression to show values and change the expression to something like:

dual(

  sum(Expression1) & chr(10) & sum(Expression2),

  sum(Expression1)

)

it´s important to uncheck any number format at Numbers Tab

Not applicable
Author

I altered my expression (which is written specifically to provide ONLY the total values) based on your advice above:

Dual(Sum([GLOBAL Efforts: Enhancement])& Chr(10)& Sum([GLOBAL Efforts: Mandatory]), Sum([GLOBAL Efforts: Enhancement]))

It appears my total values shifted down from their original location but still remain centered to the "Quarter" Dimension instead of the "Year".