How to represente my data ?

[brice_roselier]

Hello,

I've a question for represente my data because I miss ideas for this.

In a table I've my data like this (let's say bugs) :

bug_id	date_open	date_close
1	15/10	31/10
2	20/10	25/10
3	20/10	21/10
4	25/10	0
5	30/10	31/10
6	31/10	0
7	31/10	31/10

I wanna represente in time how many bugs are opened :

15/10 : 1 (1)

20/10 : 3 (1,2,3)

21/10 : 2 (1,2), 3 is closed

25/10 : 2 (1,4) 2 is closed

30/10 : 2 (1,4,5)

31/10 : 2(4,6) 5 & 7 are closed

I want to have something visual like a chart in curve. For abs I have all opened and closed date (like a union)

And in ord the number of row where open date is < abs and close date >= abs.

Have you another topic or link to explain how to do this please ?

Thanks a lot

[Juan_Tafarello]

Hello Brice,

So your issue i think can be divided.

First I would add a Master Calendar to your data. https://community.qlik.com/t5/New-to-QlikView/How-to-Create-Master-Calendar/td-p/103109

Then I would create a Line Chart using Date as the dimension and Count(Bug_ID) as a measure.https://www.youtube.com/watch?v=mhJE13XCU5Q

Best regards

[brice_roselier]

Thank you Juan,

Is your solution compatible with Qlik sense ? Your link is for Qlik view ?

Thanks a lot

[brice_roselier]

No succes with your method.

I'm trying to go by step now. For the moment I try to insert values in table. I have 1st column with dates and I'm looking for insert how many rows when date is the same value like the first column. Just this I don't manage to do.

I tried to use Aggr, RangeSum and above to compute accumulate counters. This is strange becase values are inconsistent and sometime value decrease.

How can I make this like : 

bug_id	date_open	date_close
1	15/10	31/10
2	20/10	25/10
3	20/10	21/10
4	25/10	0
5	30/10	31/10
6	31/10	0
7	31/10	31/10

15/10 | 1 | 1

20/10 | 2 | 3

25/10 | 1 | 4

30/10 | 1 | 5

31/10 | 2 | 7

Thank you