Discussion board where members can get started with QlikView.
Hi all - hopefully a basic one!
I have the following Pivot Table
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!
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.
It might be easier if you could share a sample to look at this?
Hi Sunny, cant share as it contains customer / supplier data. Sorry
You can scramble the data and then share?
Preparing examples for Upload - Reduction and Data Scrambling
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%