topic date selections issue.. in QlikView

date selections issue..

sravan_v007 — Mon, 27 Oct 2014 15:06:41 GMT

Hi All,

In my input file i have 3 fields Start_Date, End_Date and Tickets.

if i select Start_Date it shows no of tickets opened on that day and End_Date shows Tickets closed on that day.

i.e. if i select start date 11/01/2012 the count of tickets will be 44 and if end date 11/01/2012 - ticket 1076.

now my requirement is if i select single date it should show opened tickets and closed tickets on that day in 2 different text files.

Thanks in Advance,

rubenmarin — Mon, 27 Oct 2014 15:54:51 GMT

Not sure how the count of 11/01/2012 will return those results but check attachment to see how to filter both textboxes with one date.

Hope this helps.

maxgro — Mon, 27 Oct 2014 19:56:21 GMT

see attachment

MarcoWedel — Mon, 27 Oct 2014 23:59:37 GMT

maybe you could create a canonical date calendar:

hope this helps

regards

Marco