Current selection but include all for one field in Set Analysis

[annabergendal]

Hi,

I feel quite stupid, I am sure this is piece of cake...

I have a straight table where I want average sum of sales for each supplier.

So for supplier A it should say 0,14 (100/700), supplier B 0,29 (200/700) etc...

How should I write my set analysis expression if I want current selection (in the real app I want selections to be included, except for the field supplier where it should calculate on all)

Thanks

[tresesco]

Avg(Sales) ?

[morganaaron]

Sum(Sales) / Sum (Total Sales) will give you their relative % of the overall total. You could also use Sum(Sales) and tick the relative checkbox next to it.

[mdmukramali]

Dear,

=Sum(Sales)/Sum(TOTAL Sales)

[annabergendal]

I use relative button and that's perfect, if no selection has been made on supplier. But if I select supplier A, I would still like it to count the relation of ALL suppliers...

[mdmukramali · Accepted solution]

Dear,

Can you try below expression:

=Sum(Sales)/Sum(TOTAL{<Supplier=>} Sales)

and don't select relative option .

select Show in Percent from Number  Tab.

[tresesco]

In that case try:

Sum(Sales) / Sum ( ALL Sales)                  // if you want to ignore all other selections

PFA

[#8]

First solution:

sum(Sales)

/

sum(ALL Sales)

Equivalent sintax:

sum(Sales)/sum({1}TOTAL Sales)

[#9]

Check the content 'set analysis' in Qlik guide contents for more details

[#10]

Check directly to your file if you want