topic Re: Column Percentage in QlikView

Column Percentage

Sun, 15 Jun 2014 21:24:22 GMT

I'm sure I'm writing wrong this formula

=Sum({<[Codice Documento]= {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}>} [QTA 1 Documento])/sum (total({<[Codice Documento]= {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}>} [QTA 1 Documento]))

I need to calculate the column percentage...how should it be written the formula? My problem is that this variable [Codice Documento] must respect those values {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}....

thanks to everyone!

Re: Column Percentage

Clever_Anjos — Sun, 15 Jun 2014 21:31:09 GMT

It looks correct.

Make a simple test:

1) add this expression

Sum( [QTA 1 Documento])/sum (total [QTA 1 Documento])

2) Add a listbox to [Codice Documento] and select 'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI' using control-click

Is this value correct?

Re: Column Percentage

lironbaram — Sun, 15 Jun 2014 21:36:04 GMT

you need to put the total after the set analysis part

your Expression should look like this:

=Sum({<[Codice Documento]= {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}>} [QTA 1 Documento])/sum ({<[Codice Documento]= {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}>} TOTAL [QTA 1 Documento])

Re: Column Percentage

Sun, 15 Jun 2014 21:39:25 GMT

I know that I can do it in that way, but I'm forced to put that set of values within...I cannot filter those values otherwise other dimension values' change...

Re: Column Percentage

Clever_Anjos — Sun, 15 Jun 2014 21:40:00 GMT

No,

=sum( {<Dim1={"A"}>} total Expression1) and

=sum(total {<Dim1={"A"}>} Expression1) returns same value

Re: Column Percentage

Sun, 15 Jun 2014 21:41:55 GMT

thank you soooo much Liron Bra'am!!!

Re: Column Percentage

Clever_Anjos — Sun, 15 Jun 2014 21:44:45 GMT

It was just a test

Is this expression into same app, right?

Guide me to find where you are using this expression

Re: Column Percentage

Sun, 15 Jun 2014 21:49:14 GMT

I must added that formula in the chart "Riepilogo ENTRATE" and "Riepilogo USCITE". Your solutions was correct, the point is that I needed to embody [Codice Documento]= {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'} within the formula...

Re: Column Percentage

swuehl — Sun, 15 Jun 2014 21:52:43 GMT

The issue is probably due to the use of additional round brackets after total, try removing them:

=Sum({<[Codice Documento]= {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}>} [QTA 1 Documento])/sum (total {<[Codice Documento]= {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}>} [QTA 1 Documento] )

Re: Column Percentage

Sun, 15 Jun 2014 21:55:54 GMT

it says that there is an error in the expression...it doesn't work...

Re: Column Percentage

Sun, 15 Jun 2014 21:57:02 GMT

swuehl thank you for your reply though...

Re: Column Percentage

Clever_Anjos — Mon, 16 Jun 2014 00:42:22 GMT

I was late, swuehl noticed the right spot.

Re: Re: Column Percentage

Mon, 16 Jun 2014 02:46:03 GMT

swuehl 's formula is working for me. The location of 'total' before/after set analysis doesn't affect the result. Check attachment for your info.

Re: Re: Column Percentage

Mon, 16 Jun 2014 07:27:47 GMT

you were right! I'm wondering why it wasn't working earlier when I copied and pasted the formula into my QV file...

Well thank you for the explanation I'm glad that the order of the set analysis doesn't affect the result!

a big thanks to all of you swuehl, Clever Anjos and @Yang LU