Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalgoud
Creator III
Creator III

How to get the single date count by adding all the dates with time stamp.

I have a date field wtih time stamp and counts for varie on each time.

ex:              date ,                    counts

24/10/2017 09:06:36 , 35

24/10/2017 11:06:36 , 75

24/10/2017  12:06:16 , 15

25/10/2017 09:06:46 , 65

24/10/2017 12:06:36 , 95

Now i want the date fileds should contain single date with out timestamps so that if i select it will give a sum of all the counts to that particular date :                        24/10/2017  - 125

                                                 25/10/2017  - 160

is should be like a filter in the UI, Like week and year filters..

2 Replies
sunny_talwar

Create a new field like this

Date(Floor(date)) as Date,

date as TimeStamp

and then use Date as your dimension and same expression

florentina_doga
Partner - Creator III
Partner - Creator III

pls see attach