Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
ngerryts
Contributor
Contributor

Overlay selection and totals in bar graph

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.

1 Solution

Accepted Solutions
sunny_talwar

Are you looking for something like this?

Capture.PNG

View solution in original post

5 Replies
sunny_talwar

Are you looking for something like this?

Capture.PNG

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

ngerryts
Contributor
Contributor
Author

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

ngerryts
Contributor
Contributor
Author

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

Capture.PNG

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