Showing total volume for particular date

[berryandcherry6]

Hi,

i have created table where

Dimension : Date_Started

Expreesion : count({$<datatype={'signed'}>}signed)

Here it shows table like

Date_Started    Count

20-08-2016           1

20-08-2016           1

20-08-2016           1

20-08-2016           1

21-08-2016           1

21-08-2016           1

22-08-2016           1

22-08-2016           1

But i need like this

20-08-2016           4

21-08-2016           2

22-08-2016           2

How to get like this, Please help me on this.

[sunny_talwar]

Try to change your dimension to this:

Date(Floor(Date_Started), 'DD-MM-YYYY')

[sunny_talwar · Accepted solution]

Or you can even make that change in the script:

LOAD Date(Floor(Date_Started), 'DD-MM-YYYY') as Date_Started

and then you can use Date_Started as your dimension

[berryandcherry6]

Hi,

Thanks it worked,

But what makes it different by just formatting the date?

[sunny_talwar]

I am not just formatting it, I am flooring your date. It seems that your Date_Started is just formatted as a date, but includes time information as well. So each instance of your date can have a different time which was showing up as a different row. When I used Floor, it was all grouped together into a single date. Does that make sense?

If you have got what you wanted, I would request you to close this thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny