# New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
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_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

3 Replies
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

Contributor II
Author

Thank you Juan,

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

Thanks a lot

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_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

Tags
Community Browser