Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Help with Date Range chart

Hi All,

I am having some real trouble trying to create a visualisation of my data and am really hoping someone can help. Very new to Qlik so still working my way around. I am puling data straight from a number of SQL databases

I currently have the following data

StartDate - This is a variable that comes when an Time Period is selected

FinishDate - Same as above

CreatedDate - I have a large number of rows that all have a created date attached them

AssignedTo - Same as above but the rows have a persons name attached to them

When the time period is selected i get my records filtered so that only the records that are part of that time period display in a table.

What i need to do now is put a visualization in place that will show how many items on a particular day have been added for each person between the start and end date

Really stuck on this one!

5 Replies
beck_bakytbek
Valued Contributor III

Re: Help with Date Range chart

Hi Martin,

i think you need this, look at: https://community.qlik.com/thread/257523

i hope that helps

Beck

beck_bakytbek
Valued Contributor III

Re: Help with Date Range chart

for instant responce give please example data or screenshot

Not applicable

Re: Help with Date Range chart

Hi Thank you for the link but it hasn't really helped.

I have tried to put some example data in below

IterationSK, Iteration Name, StartDate, FinishDate

101, Iteration 1, 9-10-2017, 20-10-2017

WorkItemSK, WorkItem, AssignedTo, CreatedDate, IterationSK, WorkActual

1, Apply Test, John Smith, 15-09-2017, 101, 8

2, Apply Test 2, Mark Doe, 14-10-2017, 101, 4

3, Working, John Smith, 11-10-2017, 101, 0

4, Overhead, John Smith, 19-10-2017, 101, 0

5, Task, John Smith, 11-10-2017, 101, 0

6, Bug, John Smith, 11-10-2017, 101, 0

7, Defects, John Smith, 11-10-2017, 101, 0

8, Lots of Work, John Smith, 11-10-2017, 101, 0

So in the above example i would select Iteration 1 and what i am hoping to see is dates on X-Axis running from left to right is 09-10-2017 to 20-10-2017 with every day in between

I would then see a bar with a value of 1 for John Smith on the 19-10-2017 and a bar with a value of 5 for Mark Doe on the 11-10-2017

I really dont know what i need to put into my dimensions and measures

Hopefully that makes more sense

Re: Help with Date Range chart

You could use something like

startdate - finishdate as Days

and measure was  Count(Measure)

Life is so rich, and we need to respect to the life !!!
beck_bakytbek
Valued Contributor III

Re: Help with Date Range chart

Hi Martin,

check this

Community Browser