Discussion board where members can get started with Qlik Sense.
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
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:
IS that what you mean?
sum(TOTAL <Resource> Rate)
View solution in original post
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.
Sum(TOTAL <Resource, Date> Rate)
or you can try this
Aggr(NODISTINCT Sum(Rate), Resource, Date)