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: 
durgabhavani
Creator III
Creator III

How to remove duplicate dates in my calender?

Hi All,

I have one field "Date". It has following dates in my field.

Date
4/5/2015
4/5/2015
6/12/2015
7/25/2015
1/22/2015
2/14/2015
6/12/2015
6/15/2015
9/15/2015
6/12/2015
7/25/2015
1/22/2015
2/14/2015
6/12/2015
6/15/2015
9/15/2015
2/17/2015
6/12/2014
7/11/2014
8/15/2014
5/18/2014

I am using this date field in my calender object. Now i want to remove duplicate dates in my calender object. Please advice.

Thanks,

Durga

11 Replies
danieloberbilli
Specialist II
Specialist II

I think this does not work in the calendar box object.

You could create another field like

if(RealDate>='01/01/2012', RealDate, Null()) as RealDateForCalendarObj

durgabhavani
Creator III
Creator III
Author

I wrote this condition in calender expression. it is working..

Thanks,

Durga