Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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,

Actually I understand your example and thanks for your support.

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

silviaganhao
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

Example01_FilterByProduct.PNG

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

   

Example02_FilterByProduct.PNG

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

silviaganhao
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

Highlighted
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.


Example03_FilterByProduct.PNG


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

Example04_FilterByProduct.PNG



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

silviaganhao
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

silviaganhao
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

Community Browser