Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Employee
Employee

Re: Alignment Issue for Secondary Dimension Total Values

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

Re: Re: Alignment Issue for Secondary Dimension Total Values

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

Community Browser