Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Aggregate the data based on time stamp

Hi

I want the data to be aggregated based on the timestamp.

For example:

During

12/08/2012 08:00:00   -----------Product1------------12 sales occured.

12/08/2012 08:00:00   -----------Product2------------3sales occured.

12/08/2012 09:00:00------------Product1------------2sales occured.

12/08/2012 09:00:00------------Product2------------3sales occured.

This means between 7 and 8 12 sales occured and between 8 and 9 5 sales occured.

But when I create a straight table, I get the data this way.

12/08/2012 08:00:00   ---------Product1--------------14 sales occured.

12/08/2012 08:00:00   -----------Product2------------6 sales occured.

12/08/2012 09:00:00-----------Product1----------------14 sales occured.

12/08/2012 09:00:00-----------Product2----------------6 sales occured.

The data is getting aggregating based on products . Can any one help me with this please?

Regards,

Jai

2 Replies
whiteline
Honored Contributor II

Re: Aggregate the data based on time stamp

I think you have to provide some more info.

Expressions that you use.

What and how you load.

Not applicable

Re: Aggregate the data based on time stamp

Hi Jai,

Use 'Pivot Table' with the 'Timestamp' as dimension and 'Sum(Sales)' as the expression.

Regards,

Sri

Community Browser