# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## Re: Count the total records of one of the fields of the current selection in Qlik Sense

Hi Silvia,

That's what I need.

But, How Can I Calculate the "SUM FOR TOTAL REGION" Column.

That's my doubt

Regards.

Luis

Not applicable

## Re: Count the total records of one of the fields of the current selection in Qlik Sense

Hi Lucke,

My doubt is How can I calculate the "SUM FOR TOTAL REGION" column, in the first table. I'd like to know what's the correct function to calculate this unique sum by region.

I hope you can understand me.

Regards

Luis

Contributor II

## Re: Count the total records of one of the fields of the current selection in Qlik Sense

Hi Luis,

Not sure I understand, but the expression I used to calculate "SUM FOR TOTAL REGION" Column is:

Sum(Total <Region> Value)

It says that you want the total, for Region.

Regards,

Sílvia

Not applicable

## Re: Count the total records of one of the fields of the current selection in Qlik Sense

I Have a Question,

I put the function as how you placed...

But, If I filter product for e.g. Product "A", my "SUM FOR TOTAL REGION" changes, and only shows the total for the current selection.

Here's some images to support my explain:

1) The Filter

2) Sum for Total Region changes when I'm selecting a product in the table.

I'd like to get a Filter to show a product filtered and to get the Total by Region

Product "A"     |     South     |     10     |     100

I hope you can understand me

Regards, and thank you for your time

Luis

Highlighted
Contributor II

## Re: Count the total records of one of the fields of the current selection in Qlik Sense

Hi Luis,

Try this:

Sum(Total <Region>  {<Product=>}Value)

Sílvia

Not applicable

## Re: Count the total records of one of the fields of the current selection in Qlik Sense

Hi Silvia

I put the function:

Sum(Total <Region>  {<Product=>}Value) It works already.

I made a KPI to don't show fully the table, And I put the next function to get a percentage from the Total per Region (using your function): sum([Sum of Product]) / Sum(Total <Region> {<Product=>}[Sum of Product])

But It doesn't show only the percentage for the Region from a Product selected

I expected to show as result:

sum([Sum of Product]) / Sum(Total <Region> {<Product=>}[Sum of Product])

10 / 100 = 10 %

Once again... Could you help me in my doubt?

Regards

Luis

Contributor II

## Re: Count the total records of one of the fields of the current selection in Qlik Sense

Hi Luis,

Try this:

Sum(Value) / Sum(Total <Region> {<Region= p(Region),Product=>} Value)

Regards,

Sílvia

Not applicable

## Re: Count the total records of one of the fields of the current selection in Qlik Sense

Hi Silvia,

That's the correct answer for my case.

It works perfectly...

Thank you very much, It's good to receive part of your knowledge in this kind of cases.

Regards

Luis

Contributor II

## Re: Count the total records of one of the fields of the current selection in Qlik Sense

Great Luis

Please close this thread by marking correct and helpful responses, if you got what you were looking for.

Qlik Community Tip: Marking Replies as Correct or Helpful

Regards,

Sílvia