Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

working with multiple dates

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

CanonicalDatecreatedDateStatusPriorityInvolve Tech TeamTicket TypesolveddateDateTypeId
3/17/20143/17/2014SolvedUrgentNoValid Issue3/17/2014created1521
3/17/20143/17/2014SolvedUrgentNoValid Issue3/17/2014solve1521
11 Replies
anuradhaa
Partner - Creator II
Partner - Creator II
Author

it works . thank you

sujeetsingh
Master III
Master III

You are welcome