Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Calculate sum, 3 dimensions 1 measure

Hi community,

I  wish you helped me figuring out the following:

I am using a table (3 dimensions : Resource, Timestamp, Date, 1 measute :Rate).

Date is calculated during the data loading

LOAD SAMPLED,

DAYNAME(SAMPLED) AS Date,

..

I thought that the following would sum Rate per resource per date but it just populates the existing measure per resource per timestamp:

sum(Aggr(Rate,Resource,Date))

Any help?

 

Sample Data:

ResourceDateSAMPLEDRate
A12/1/20181/12/2018 16:156144799
A12/1/20181/12/2018 16:307466835
A12/1/20181/12/2018 16:456278066
A12/1/20181/12/2018 17:006138748
B12/1/20181/12/2018 16:156954240
B12/1/20181/12/2018 16:308249710
B12/1/20181/12/2018 16:456817208
B12/1/20181/12/2018 17:007067755
1 Solution

Accepted Solutions
Highlighted

IS that what you mean?

sum(TOTAL <Resource> Rate)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
Highlighted
Partner
Partner

Hi Nikolis,
Try changing the expression.. it should be like this:

Aggr( Sum(Rate), (Resource,Date) )

This way, you'll sum Rate, grouping by Resource and Date.

Please, let me know if it works.

 

Att, Fukumoto.

Highlighted

Try this

Sum(TOTAL <Resource, Date> Rate)

or you can try this

Aggr(NODISTINCT Sum(Rate), Resource, Date)
Highlighted

IS that what you mean?

sum(TOTAL <Resource> Rate)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post