# Qlik Sense App Development

New Contributor

## How to implement set expression and Total function together?

For Example,

A Pivot table has Region in Columns and Classifications in Rows as shown in the screenshot attached

I am trying to obtain the total values across the regions for individual Classifications to be shown in every cell of the classification only for the data pertaining to Round_id =2. Please refer to the screenshot for better understanding of the expectation.

This is the formula, I have been using "sum( {\$<Round_ID={'2'}>} Total<Classification> Points_Earned)" for that. However, the result is ignorant of the total function I put in the expression. That means the same result is obtained even without the Total Function "sum( {\$<Round_ID={'2'}>} Points_Earned)". Can you please correct me for where the mistake is?

Note: When I don't use the set expression alongside the Total function, "sum(Total<Classification> Points_Earned)", the result comes out correctly considering the total function. However, I want this expression to be modified to account for specific round_id's embedded in the set expression.

Labels (1)
• ### Total Function and Set expression combination

3 Replies
Valued Contributor II

## Re: How to implement set expression and Total function together?

can u share a sample application

Partner

## Re: How to implement set expression and Total function together?

Hi Subramanir,

If I'm following your problem, you want all the same values for all regions. Then why do this? Why don't create a normal table with Sum([YourField]) and the Classification as dimension?

Jordy

Climber

Work smarter, not harder
Partner

## Re: How to implement set expression and Total function together?

I see that you have deleted your last response, but if you use a total function,  you should put it in front of the set analysis:

``````sum( {\$<Round_ID={"\$(=max(Round_ID))"}>}  Total<Classification> Points_Earned)

Change into:
sum(Total  {\$<Round_ID={"\$(=max(Round_ID))"}>}  Points_Earned)``````

Jordy

Climber

Work smarter, not harder