topic Re: How to get the single date count by adding all the dates with time stamp. in QlikView

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

vishalgoud — Wed, 25 Nov 2020 16:16:04 GMT

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..

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

sunny_talwar — Tue, 24 Oct 2017 12:48:17 GMT

Create a new field like this

Date(Floor(date)) as Date,

date as TimeStamp

and then use Date as your dimension and same expression

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

florentina_doga — Tue, 24 Oct 2017 12:56:01 GMT

pls see attach