Overlay selection and totals in bar graph

[Anonymous]

I want to create a single bar graph with live results overlayed in front of the static results for all data (i.e. ignoring selection).  Basically in a single graph one will be able to see the selected data as a proportion of the total given the dimension.  It is easy enough to create the two expressions but I can't seem to overlay them.  In Excel I would simply set the overlap equal to 100%.   Is there a way to do this in QV and I'm simply missing something simple?

Attached is an example QV file with the graph.

[sunny_talwar · Accepted solution]

Are you looking for something like this?

[MarcoWedel]

Hi,

maybe you could use the "Set Reference" option of your bar chart?:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Ajax/WebView_BarChart.ht...

hope this helps

regards

Marco

[Anonymous]

It might be picky of me, but the pop-up totals are showing the difference and not the actual total, but the effect is exactly what I'm looking for.

Thanks

[Anonymous]

This could work, but the data gets updated monthly and I'll have large number of graphs to set the reference each time.

But I did learn something new, thanks!

[sunny_talwar]

May be use a popup text expression

But make sure you uncheck 'Pop-up Labels' on the presentation tab....