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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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