topic Re: problem with all / total in QlikView

problem with all / total

Tue, 24 Apr 2012 00:47:58 GMT

Hello everybody:

I have that rows

año ventas cliente

2012 10 cl1

2012 20 cl1

2012 40 cl2

2011 15

The year is in a multiple selection object

i need the expression that evalue the total of venta of client1 divide by the total of year

for example cl1 is 30 /70 for the 2012

but the sum(all ventas) returns 85 and sum({$<año=>} all ventas) not run.

How i obtain the sum of all ventas for the year that i selected in the multiple selection.

Thanks in advance.

problem with all / total

adhudson — Tue, 24 Apr 2012 01:58:34 GMT

Hi,

Kindly tell me which type of object you are using to visualize the data.

So that, it will be easy to give appropriate expressions.

Regards

Andrew Hudson

Re: problem with all / total

Tue, 24 Apr 2012 06:56:20 GMT

Hi,

Please go through the attachment where i showed the o/p you want.

-yojas

Re: problem with all / total

Tue, 24 Apr 2012 07:07:07 GMT

Hi,

While It should work as is shown in attached application in previous answer.

You can also try doing it in by sum(ventas)/sum(total <año> ventas)

the differrence between all and total is that total respects the selections but does not respect the dimensions of the chart but all ignores selecttion as well as dimensions.

If, You want to ignore selections then you can use all.

So, the same way it can be

sum(ventas)/sum(all <año> ventas)

Ashutosh