Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Date field not working properly

Hi All ,

How to show the date_created as '2018-07-25'  as it got 3 different timestamp.date_created.PNG

My requirement -

to show  '2018-07-25'  on one line as it is a pivot table instead of three line coming ,

I used this set analysis in dimension

=Date ( Aggr(Min(TOTAL <batch_ref> (date_created)), batch_ref, (date_created)) )

, but still getting three rows .like this

2.PNG

Thanks .

1 Solution

Accepted Solutions
sunny_talwar

Convert your timestamp to date using a calculated dimension

Date(Floor(date_created))

View solution in original post

2 Replies
sunny_talwar

Convert your timestamp to date using a calculated dimension

Date(Floor(date_created))

mtucholski
Creator
Creator

Hi,

please change the topic so it would serve it's job.

When it comes to your question, try this one:

floor(date_created)