Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
craig157
Contributor

Help required for Burndown Chart

Hi all - hopefully a basic one!

I have the following Pivot Table

Serial NumberConsumable
06/12/1705/12/1704/12/1703/12/17
123456789APart 126%31%32%32.5%
Part 265%65%71%72%
Part 312%16%42%54%
EIT999101012Part 129%33%33%41%
Part 299%99%99%99%
Part375%77%79%81%
XYZXYZTUITI123Part 243%47%52%55%
CYNCYNCYN101Part 199%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

5 Replies
craig157
Contributor

Re: Help required for Burndown Chart

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.

Re: Help required for Burndown Chart

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

craig157
Contributor

Re: Help required for Burndown Chart

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

Re: Help required for Burndown Chart

You can scramble the data and then share?

Preparing examples for Upload - Reduction and Data Scrambling

craig157
Contributor

Re: Help required for Burndown Chart

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%