Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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