Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
brice_roselier
Contributor II
Contributor II

How to represente my data ?

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_iddate_opendate_close
115/1031/10
220/1025/10
320/1021/10
425/100
530/1031/10
631/100
731/1031/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

3 Replies
Juan_Tafarello
Support
Support

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
Contributor II
Contributor II
Author

Thank you Juan,

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

Thanks a lot

brice_roselier
Contributor II
Contributor II
Author

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_iddate_opendate_close
115/1031/10
220/1025/10
320/1021/10
425/100
530/1031/10
631/100
731/1031/10

 

15/10 | 1 | 1

20/10 | 2 | 3

25/10 | 1 | 4

30/10 | 1 | 5

31/10 | 2 | 7

 

Thank you