Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count date

I have Date column named newdate.

p1.png

I want to create a new table which has two columns. a date column and count column which shows the count of each date.

For example 02/05/2016 will have count 1.

13 Replies
Chanty4u
MVP
MVP

use rowno() 

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

If you see a 'date' value twice then there are two different values. Your 'date' is most likely a timestamp formatted as a date. So you don't see the time parts of the timestamp that do differ.


talk is cheap, supply exceeds demand
jonathandienst
Partner - Champion III
Partner - Champion III

Change the load the table containing the date to:

     LOAD ...

          Date(Floor(newdate)) As newdate,

          Time(Frac(newdate)) As newtime,  // if you need the time part

          ...

This will prevent the timestamp problem explained by Gysbert.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Date:

LOAD * INLINE [

    DATE

    01/10/2015

    01/10/2014

    05/10/2013

    01/10/2014

    01/10/2015

];

try  Count(DATE)