Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.

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".