Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jayeshmule
New Contributor II

Need formula for Defect Burn Down Rate

DefectBurndown.JPG

Please help to get formula for this graph in Qliksense

Tags (1)
1 Solution

Accepted Solutions
etrotter
Contributor II

Re: Need formula for Defect Burn Down Rate

Are you using a master calendar?

5 Replies
etrotter
Contributor II

Re: Need formula for Defect Burn Down Rate

Once your data is loaded, select line chart and your months would be your dimensions, and your Sum([Defect Burndown Rate]) would be your expression and it will create that graph.

jayeshmule
New Contributor II

Re: Need formula for Defect Burn Down Rate

the data of dimension is like a current month but I am not sure How to divide the month in different weeks like Week1 Week 2 Week 3 Week4 and Week 5.

etrotter
Contributor II

Re: Need formula for Defect Burn Down Rate

Are you using a master calendar?

jayeshmule
New Contributor II

Re: Need formula for Defect Burn Down Rate

No Erica I am not using Master Calendar...Lets say if CurrentMonth is September so I want to divide the current month in 5 Weeks and use it as Dimension.

priyalvp24
Contributor

Re: Need formula for Defect Burn Down Rate

Create week using master calendar.

Use that week field as dimension.