topic Re: Bar Chart Label, but Complex in QlikView

Bar Chart Label, but Complex

Wed, 03 Jul 2013 15:31:34 GMT

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!

Re: Bar Chart Label, but Complex

Wed, 03 Jul 2013 15:47:37 GMT

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 )

Re: Bar Chart Label, but Complex

Wed, 03 Jul 2013 16:13:02 GMT

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

Re: Bar Chart Label, but Complex

Wed, 03 Jul 2013 16:24:51 GMT

Isn't this what you want?

Re: Bar Chart Label, but Complex

Wed, 03 Jul 2013 16:34:58 GMT

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