Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
rupshall10
Contributor II
Contributor II

Sum <Total>

I have a question that may not be possible.

I have the below table in Qlik which shows how many people have started a particular course across all of our sites.

It also shows the cost of that course. (I will format the numbers into currency)

I would like to display a text object that will show the total spent in the table.

In this case it should show (2*4000) + (9*3000) + (6*3000) + (2*9000) + (4*5000) + (3*5000) = £106 000 (if my math can be trusted)

The dimensions in question are Qualification and CourseCost.Can anyone provide any guidance from this info alone?

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Perhaps something like

=Sum(Aggr(CourseCost * Count({<ApprenticeshipStatus={'Started'}>} atID), Qualification))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
Anonymous
Not applicable

Hi Richard,


Can you post the sample application ? to understand clearly about your requirement.



Thanks,

Venkata Sreekanth

rupshall10
Contributor II
Contributor II
Author

Hi Venkata

Unfortunately I cant easily due to the nature of the data and the complexity of the application on the whole.

But in this particular instance I have a table that is loaded with The Qualification Name and Cost - as shown in the table.

i have a separate table that loads all the sites.

So the formula I'm looking for will involve the dimensions Qualification, CourseCost and possible SiteName.

The expression used in the table is:

=Count({<ApprenticeshipStatus={'Started'}>}atID)

ApprenticeshipStatus - simply shows all those who have started, and atID is the unique Identifier for each apprentice

jonathandienst
Partner - Champion III
Partner - Champion III

Perhaps something like

=Sum(Aggr(CourseCost * Count({<ApprenticeshipStatus={'Started'}>} atID), Qualification))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein