Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stats101
New Contributor

Group by Date not working

Hi,

I am trying to group a table that has hourly entries such that it rolls in up into daily entries; I have the following in my load script:

[Daily Count]:

Noconcatenate

LOAD

    Date(Floor(Date),'DD/MM/YYYY') AS Date,

    Sum(Count) AS DailyCount

Resident [Hourly Count]

Group By Date;

However it still shows the date as repeated values. Any suggestions to what I could be doing wrong?


Thanks,

Tags (1)
1 Reply

Re: Group by Date not working

Try this

[Daily Count]:

Noconcatenate

LOAD Date

    Sum(Count) AS DailyCount

Group By Date;

LOAD Date(Floor(Date),'DD/MM/YYYY') as Date,

    Count

Resident [Hourly Count];

Community Browser