Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
berryandcherry6
Contributor II

Showing total volume for particular date

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.

Tags (1)
1 Solution

Accepted Solutions

Re: Showing total volume for particular date

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

4 Replies

Re: Showing total volume for particular date

Try to change your dimension to this:

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

Re: Showing total volume for particular date

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
Contributor II

Re: Showing total volume for particular date

Hi,

Thanks it worked,

But what makes it different by just formatting the date?

Re: Showing total volume for particular date

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