Bar Chart Label, but Complex

[#1]

Hi! I'm creating a bar graph and want to show a label with the total and then then the number of a subset of the total.

For instance, imagine Fruit is comprised of Oranges (20) and Apples (10). My bar chart would show Fruit = 30.  But instead of the label saying just 30, I want it to show 30 (10) to show the amount of apples as a subset.

Any ideas?

Thanks!

[#2]

Where do you want to show the label? Values on Data Points?  You could do something like this in the expression:

dual ( 

          sum( fruits ) & '   ( ' & sum( {$<fruit_type={'apples'}>} fruits ) & ' ) '

          , sum( fruits )

)

You can read more about the dual() function in the QlikView Help ( F1 )

[#3]

Thanks Carlos! I should have been more detailed as the above was a great solution for the title of the graph but not for each individual bar.

I have attached a spreadsheet with the granularity that I was looking for out of the dual function. Your solution above worked well in that it showed 150 (100), the Total across Titles and the Total In Scope. However, I couldn't figure out how to make each bar show the same level of detail.

I would show the titles as the y axis to the flagpole. The Totals would be the shown, with the values in the parenthesis being in scope. For instance, the Director bar would show 60 (40).

[#4 · Accepted solution]

Isn't this what you want?

[#5]

Oh I see what I was missing now! Thank you!