Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jayati_shrivast
Contributor III
Contributor III

date field in filter pane

Hi all,

I have a date field in the format dd-mm-yyyy, hh-mm-ss AM/PM. It has values as follows-

19-10-2018 11:06:53 AM

19-10-2018 11:07:56AM

19-10-2018 11:09:58AM

20- 11-2018 12:09:59 PM and so on.......

 

I need to apply this field in the filter pane showing dates as 19 oct 2018, 20 oct 2018....but because of time the dates are getting repeated in filterpane like 19 oct 2018, 19 oct 2018 19 oct 2018, 20 oct 2018, 20 oct 2018 ......

how can i implement this??? pls help me out

 

 

1 Solution

Accepted Solutions
PradeepReddy
Specialist II
Specialist II

try like this..

Date(floor(TimestampField),'DD MMM YYYY')

View solution in original post

3 Replies
PradeepReddy
Specialist II
Specialist II

try like this..

Date(floor(TimestampField),'DD MMM YYYY')

santhiqlik
Creator
Creator

Hi,
Please try this..
Date(Date#(subfield(TimestampField,' ',1),'DD-MM-YYYY'),'DD MMM YYYY')

1. Subfield separates date from timestamp.
2. Date# interprets the date in given format.
3. Date converts to required format.
santoshknc
Partner - Creator
Partner - Creator

I also got similar issue, so i had resolved it using this expression added in the script

DATE(FLOOR(LEFT(Date_Field,10)), 'DD/MM/YYYY')

 

Thanks,

Santosh.