Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

problem with all / total

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.

1 Solution

Accepted Solutions
adhudson
Creator II
Creator II

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

View solution in original post

3 Replies
adhudson
Creator II
Creator II

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

Not applicable
Author

Hi,

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

-yojas

Not applicable
Author

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