topic Re: Current selection but include all for one field in Set Analysis in QlikView

Current selection but include all for one field in Set Analysis

annabergendal — Thu, 20 Nov 2014 09:28:57 GMT

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

Re: Current selection but include all for one field in Set Analysis

tresB — Thu, 20 Nov 2014 09:38:40 GMT

Avg(Sales) ?

Re: Current selection but include all for one field in Set Analysis

morganaaron — Thu, 20 Nov 2014 09:43:59 GMT

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.

Re: Current selection but include all for one field in Set Analysis

mdmukramali — Thu, 20 Nov 2014 09:45:09 GMT

Dear,

=Sum(Sales)/Sum(TOTAL Sales)

Re: Current selection but include all for one field in Set Analysis

annabergendal — Thu, 20 Nov 2014 09:50:31 GMT

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

Re: Current selection but include all for one field in Set Analysis

mdmukramali — Thu, 20 Nov 2014 09:58:16 GMT

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.

Re: Re: Current selection but include all for one field in Set Analysis

tresB — Thu, 20 Nov 2014 10:08:51 GMT

In that case try:

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

PFA

Re: Current selection but include all for one field in Set Analysis

Thu, 20 Nov 2014 10:49:21 GMT

First solution:

sum(Sales)

sum(ALL Sales)

Equivalent sintax:

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

Re: Current selection but include all for one field in Set Analysis

Thu, 20 Nov 2014 10:52:44 GMT

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

Re: Current selection but include all for one field in Set Analysis

Thu, 20 Nov 2014 10:55:17 GMT

Check directly to your file if you want

Re: Current selection but include all for one field in Set Analysis

annabergendal — Thu, 20 Nov 2014 13:57:37 GMT

Thanks! This did the job! Now the calculation is made on current selection, but for supplier where it includes all.