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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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