topic Re: Bar chart solution please in QlikView

Bar chart solution please

Wed, 25 Nov 2020 16:16:04 GMT

Location	UNIT	SEATS	HC	VAC
Chicago	Warehouse	100	70	30%
Chicago	Shop	50	25	50%
Washington	Mall	200	80	20%
Washington	Corporate	100	50	50%

I need Stackable bar chart by Unit by Location ( Ex : at location Chicago there are 150 seats,95 hc and 37% vacancy)

Each stack in a bar should show total of seats and HC and a bubble or check box to show Vacancy%.Pimary x- axis value should show Seats and Empty Seats and secondary x-axis value should show vacancy %.Not sure if this is possible.

Thanks,

Alva.

Re: Bar chart solution please

sunny_talwar — Mon, 21 Mar 2016 02:29:02 GMT

This?

Re: Bar chart solution please

sunny_talwar — Mon, 21 Mar 2016 02:36:29 GMT

How are you getting a vacancy of 37% at Chicago location?

Re: Bar chart solution please

settu_periasamy — Mon, 21 Mar 2016 02:37:59 GMT

Hi Sunny,

I think it should be (3rd exp)

=1-Sum(HC)/Sum(SEATS)

Number format (%)

- but not sure, this is what he needs..

Re: Bar chart solution please

sunny_talwar — Mon, 21 Mar 2016 02:40:00 GMT

Makes sense

Re: Bar chart solution please

Mon, 21 Mar 2016 02:58:17 GMT

Thank you.I think this is almost what they need.Thank you very much.

Re: Bar chart solution please

sunny_talwar — Mon, 21 Mar 2016 03:00:58 GMT

Awesome