Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Try to change your dimension to this:
Date(Floor(Date_Started), 'DD-MM-YYYY')
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
Hi,
Thanks it worked,
But what makes it different by just formatting the 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