topic Sum <Total> in QlikView

Sum

rupshall10 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Anonymous — Mon, 26 Mar 2018 08:02:56 GMT

Hi Richard,

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

Thanks,

Venkata Sreekanth

rupshall10 — Mon, 26 Mar 2018 08:16:20 GMT

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 — Mon, 26 Mar 2018 08:21:27 GMT

Perhaps something like

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