topic Re: Help creating a chart!!! in QlikView

Help creating a chart!!!

bazzaonline — Wed, 25 Nov 2020 16:16:04 GMT

Hello, I need to create a chart that is based on two existing dimensions but not sure how??

I have two date fields

Start Date

Finish Date

I need to create a chart that shows open jobs at the end of each month. I guess I need to create a dimension that can count the number of open jobs at the end of the month?

Any ideas??

Thanks Paul

Re: Help creating a chart!!!

sunny_talwar — Wed, 16 Mar 2016 10:38:57 GMT

Do you have a sample you can share with us?

Re: Help creating a chart!!!

Anonymous — Wed, 16 Mar 2016 10:40:25 GMT

Did you check this?

Recipe for a Gantt chart

Re: Help creating a chart!!!

ramasaisaksoft — Wed, 16 Mar 2016 10:45:28 GMT

Hi Paul,

My Assumptions are like below

Expression u can write below one

=if(job_type='Open',

aggr(sum(jobs),Month(Start Date))

you can get like this.If you are not clear send us some sample data and required output so that we will help to u

Re: Help creating a chart!!!

Kushal_Chawda — Wed, 16 Mar 2016 10:55:38 GMT

what is logic to find out the number of open jobs?

Re: Help creating a chart!!!

bazzaonline — Wed, 16 Mar 2016 10:58:18 GMT

If at the given date the start data is < the month and the finish date is > that the month.

Re: Help creating a chart!!!

bazzaonline — Wed, 16 Mar 2016 11:06:36 GMT

All, Below is an example of what I need to do. So it would show at the end of Jan 2 open jobs (Jobs 2 & 3) at the end of feb 3 open (jobs 3, 5 and 6 etc)

Job Number	Start Date	Finish Date	Job Number	End Jan	End Feb	End Mar
1	01/01/2016	01/01/2016	1	0	0	0
2	01/01/2016	01/02/2016	2	1	0	0
3	01/01/2016	01/03/2016	3	1	1	0
4	01/02/2016	01/02/2016	4	0	0	0
5	01/02/2016	01/03/2016	5	0	1	0
6	01/02/2016	01/04/2016	6	0	1	1
7	01/03/2016	02/03/2016	7	0	0	0
8	01/03/2016	02/03/2016	8	0	0	0
9	01/03/2016	15/04/2016	9	0	0	1

Re: Help creating a chart!!!

MayilVahanan — Wed, 16 Mar 2016 11:31:54 GMT

PFA

Hope it helps

JobNumber	Month	Jan	Feb	Mar	Apr
1		0	0	0	0
2		1	0	0	0
3		1	1	0	0
4		0	0	0	0
5		0	1	0	0
6		0	1	1	0
7		0	0	0	0
8		0	0	0	0
9		0	0	1	0