topic Re: working with multiple dates in QlikView

working with multiple dates

anuradhaa — Tue, 08 Apr 2014 06:48:44 GMT

Hi,

In my data set i'm using createdate and solve date. when the user select date in list box i need to show all the data in that date (both solve and create)

some tickets create in jan and close in feb. so i need to display that when he select jan. or feb.

i did it using canonical date and put date time field based on create or solve.

now i want to merge below two records and display one record.

Created date/status/priority/ticket type /Solve date

here this data set should satisfy above condition in data setection.

Thanks

CanonicalDate	createdDate	Status	Priority	Involve Tech Team	Ticket Type	solveddate	DateType	Id
3/17/2014	3/17/2014	Solved	Urgent	No	Valid Issue	3/17/2014	created	1521
3/17/2014	3/17/2014	Solved	Urgent	No	Valid Issue	3/17/2014	solve	1521

Re: working with multiple dates

sujeetsingh — Tue, 08 Apr 2014 07:01:58 GMT

can you give the sample

Re: working with multiple dates

anuradhaa — Tue, 08 Apr 2014 07:08:26 GMT

i have below two records

CanonicalDate	createdDate	Status	Priority	Involve Tech Team	Ticket Type	solveddate	DateType	Id
1/31/2013	1/31/2013	Closed	Normal	Yes	Valid Issue	2/5/2013	created	784
2/5/2013	1/31/2013	Closed	Normal	Yes	Valid Issue	2/5/2013	solve	784

and i want to merge them and get below single record based on id

Id	Status	Priority	Involve Tech Team	createdate	solveddate	[Ticket Type]
784	Closed	Normal	Yes	1/31/2013	2/5/2013	Valid Issue

Re: working with multiple dates

sujeetsingh — Tue, 08 Apr 2014 07:18:49 GMT

Use group by when resident load

Re: working with multiple dates

anuradhaa — Tue, 08 Apr 2014 07:34:43 GMT

pls use attached qvw

Re: working with multiple dates

sujeetsingh — Tue, 08 Apr 2014 08:53:39 GMT

Anu ,

Please explain or write upin your sample that what do yo really want in it .

Re: working with multiple dates

anuradhaa — Tue, 08 Apr 2014 09:02:08 GMT

Hi,

here i want to display ticket statistics. here a ticket has id, create date, slove date etc.

some tickets were created in feb and closed in march.

so as you can see i want a calendar to select months.

so when i select feb, it has to show all tickets close or solve in feb.

so i use canonical date and use that to display.

but when i do that it gives me two records, one for create and one for solve for same id.( you can see it in my table top)

i need to merge that. i use if condition and did it (below) but when i do that that is only show the tickets created in selected month. but i want to display created and solve. both.

hope this will help

thanks for your replys

Re: working with multiple dates

sujeetsingh — Tue, 08 Apr 2014 09:22:14 GMT

See this it works fine to me

Re: working with multiple dates

anuradhaa — Tue, 08 Apr 2014 09:29:30 GMT

no, take id 1436. it has two records. i want to get one record using these two records

Re: working with multiple dates

sujeetsingh — Tue, 08 Apr 2014 09:58:11 GMT

Anu,

This is happening just due to cronical date in dimension as their are values hence try using a valid logic for taking any one based on latest date .

Re: working with multiple dates

anuradhaa — Tue, 08 Apr 2014 10:19:58 GMT

it works . thank you

Re: working with multiple dates

sujeetsingh — Tue, 08 Apr 2014 10:46:24 GMT

You are welcome