topic Re: Count date in QlikView

Count date

Fri, 05 Feb 2016 17:09:10 GMT

I have Date column named newdate.

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.

Re: Count date

Chanty4u — Fri, 05 Feb 2016 18:07:36 GMT

create a stright table

with newdate dimension and add

expression as count(distinct(newdate))

Re: Count date

Gysbert_Wassenaar — Fri, 05 Feb 2016 18:11:30 GMT

Add a measure as second column. count(newdate) should work if newdate is not a key field linking two tables. Otherwise count another non-key field.

Re: Count date

HirisH_V7 — Fri, 05 Feb 2016 18:17:17 GMT

Hi ,

Is this,

Re: Count date

Fri, 05 Feb 2016 18:17:44 GMT

You can create a table:

dimension: newdate

expression: count(newdate)

Or create a list, showing frequency.

Re: Count date

mithilesh17 — Fri, 05 Feb 2016 18:19:49 GMT

Hi,

why you need another table???

simply use newdate as dimension and count(newdate) as expression on front-end in straight table.

Regards,

Re: Count date

Mon, 08 Feb 2016 19:27:05 GMT

newtab:

Load

(newdate) as Dateee,

count([distinct] newdate) as c

RESIDENT root;

Is this right? It gives this error

The following error occurred:

Error in expression: ')' expected

Re: Count date

Mon, 08 Feb 2016 20:04:49 GMT

Hi,

How to do that? can you give me the script for it.

Re: Count date

Mon, 08 Feb 2016 20:38:10 GMT

even if first date is twice it is not showing as one. it is showing two different entries.

Re: Count date

Mon, 08 Feb 2016 21:07:12 GMT

It does not work. It gives frequency of every date as 1. where as we can see that the first date itself is repeated. It should have been clubbed and shown as frequency 2.

Re: Count date

Chanty4u — Tue, 09 Feb 2016 05:07:45 GMT

use rowno()

Re: Count date

Gysbert_Wassenaar — Tue, 09 Feb 2016 06:41:43 GMT

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.

Re: Count date

jonathandienst — Tue, 09 Feb 2016 06:50:44 GMT

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.

Re: Count date

Anonymous — Tue, 09 Feb 2016 07:09:51 GMT

Date:

LOAD * INLINE [

DATE

01/10/2015

01/10/2014

05/10/2013

01/10/2014

01/10/2015

];

try Count(DATE)