topic Re: Help required for Burndown Chart in QlikView

Help required for Burndown Chart

craig157 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all - hopefully a basic one!

I have the following Pivot Table

Serial Number	Consumable	06/12/17	05/12/17	04/12/17	03/12/17
123456789A	Part 1	26%	31%	32%	32.5%
	Part 2	65%	65%	71%	72%
	Part 3	12%	16%	42%	54%
EIT999101012	Part 1	29%	33%	33%	41%
	Part 2	99%	99%	99%	99%
	Part3	75%	77%	79%	81%
XYZXYZTUITI123	Part 2	43%	47%	52%	55%
CYNCYNCYN101	Part 1	99%	100%	100%	100%

Now I want to display this as a burndown chart so we can try to predict when they will hit 0%

How would I get this to display as just now they keep grouping into Consumable Parts?

I've had to enabled some If Statements to ensure the different unit types come out as a Percentage.

Any help would be appreciated!

Cheers

Craig

craig157 — Wed, 06 Dec 2017 13:50:51 GMT

Sorry should have said!

I'd like the Percentage to be the burndown, but showing how a certain Serial Numbers Consumable is going.

Then I can do a report of what Serial Numbers have a consumable with a low percentage.

sunny_talwar — Wed, 06 Dec 2017 13:55:22 GMT

It might be easier if you could share a sample to look at this?

craig157 — Wed, 06 Dec 2017 13:57:24 GMT

Hi Sunny, cant share as it contains customer / supplier data. Sorry

sunny_talwar — Wed, 06 Dec 2017 14:00:58 GMT

You can scramble the data and then share?

craig157 — Wed, 06 Dec 2017 14:01:59 GMT

This is what currently is produced, but those lines are just consumable numbers only.

I don't want the client to have to add a filter of the serial number as they would rather only see data less than 25%