topic Need help in expression. Region sales for managers in QlikView

Need help in expression. Region sales for managers

Wed, 26 May 2010 12:32:49 GMT

Hello!

There is a table with three columns.

LOAD * INLINE [

region, pers, sales

1, 1, 11

1, 2, 12

2, 3, 23

2, 4, 24

];

And there is a chart with dimension "pers" and expression sum(sales)

Need second expression with region sales for persons.

The answer for first and second person is 11+12=23, for third and fourth person is 23+24=47

What QV function can help me?

Wed, 26 May 2010 12:56:30 GMT

see this attachment

thanks

Zaman

Wed, 26 May 2010 13:22:20 GMT

Thanks, Zaman, but need another thing.

I added hardcode to my example in original post. That is our chart.

Our chart shall contain one dimension and two expression

boorgura — Wed, 26 May 2010 13:33:24 GMT

You can achieve that by having 2 dimensions:

Region and Person

And expression will be:

Sum(Sales)

Sum(all <region> Sales)

Let me know if it works.