Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

I think you have to provide some more info.

Expressions that you use.

What and how you load.

Not applicable
Author

Hi Jai,

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

Regards,

Sri