Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

Good day,

I was wondering if there is any Set Analisys statement or an example to apply it to my case.

I want to make an indicator of the Total Sold Product (PV) by Region (REG) of the current selection among the total of Sold Products of the Region to which it belongs.

The formula should look something like this:

Indicator = (PV of the current selection) / (PV of the total of the Region to which it belongs)

* PV = Products Sold

I would greatly appreciate your help, as I have no idea how to do it.

regards

Luis

18 Replies
silviaganhao
Contributor II

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

Hi Luis,

See if this helps

e.png

Regards

Sílvia

Not applicable

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

Hi Silvia,

Nice to meet you and thank you for your prompt answer.

Perhaps I didn't write my question correctly.

What I want is, when I select an item from one camp, show from this selection a Subtotal for a camp selected.

For Example in your table:

If I select in the table "A" in the camp "Product" In "Indicator" show the Total for the Region: "100" and after that show an indicator in percent equal to = Product / Total Region

I hope, you can understand my case.

Thank you very much Silvia

Luis

ogster1974
Honored Contributor II

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

Try inserting this measure into a table with dimension of REG

=aggr(sum({$}PV)/sum(PV) , REG)

Regards

Andy

german24
New Contributor III

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

Hi,

try this...

Continuing with Silvia's response.

Best regards,

German

Not applicable

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

What is the function for the Camp [Sum for Total Region]?

Regards

Luis

Not applicable

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

Hi German,

Sorry, but I didn't understand you answer...

Regrets

Luis

Not applicable

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

Hi Andy,

I working with the Silvia's example. But I can't get it...

I think you function is the result what I want to get.

but the first part (To get the Total per Region) I can't...

Do you know how can I solve it?

Regards

Luis

silviaganhao
Contributor II

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

Hi Luís,

Gving what you request, I think Germán's answer is the response you want,

The first indicator, shows th total for the region associated with the product you choose, I than the total of that product in that region.

Regards,

Sílvia

Highlighted
Employee
Employee

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

Here is an example with a pivot table.
In the pivot table there is a field that calculates the total percentage per product in the region and the total percentage of the selection if any is made. Or do You require KPI objects per region?

example_pivot.png

Community Browser