topic Re: Partial Sum in Straight Table in QlikView

Partial Sum in Straight Table

Mon, 14 Sep 2015 07:57:14 GMT

Hi,

I am using a straight table. I want the Total Sum of field should be based on the rows which are getting display after selection.

The total should be vary based on 'Top N' values.

Could you please help me on this? Do I need to use Aggr function for that?

How to display total in Straight Table based on the 'Top N' Selection?

Please see the attached screen shot. I am selecting Top 5 records but still it is showing the whole Total.

Thank you.

Regards,

Poonam Patil

Re: Partial Sum in Straight Table

sasiparupudi1 — Mon, 14 Sep 2015 08:10:24 GMT

Undert total mode,choose sum of rows option in the expression tab for your expression.

hth

Sasi

Re: Partial Sum in Straight Table

qlikviewwizard — Mon, 14 Sep 2015 08:22:02 GMT

Hi,

Can you attach the sample data?

Re: Partial Sum in Straight Table

Anonymous — Mon, 14 Sep 2015 09:12:51 GMT

please post the expression you are using,so can help

Re: Partial Sum in Straight Table

Mon, 14 Sep 2015 09:12:52 GMT

Hi,

Please see the attached example.

I have used Straight Table. and displaying Top 'N' records by setting variable in 'Max Number ' field.

if I use Pivot Table, I can get Total by marking partial Sum option but in Straight Table it is not possible.

But in Pivot Table I cannot set variable to get max record. So I need to use Straight Table.

In the attached file, I am showing Top 3 records, but it is displaying whole total. But I want to show only Top 3 records Total. (Please see attached 'Total.QVW' and 'Example.jpg')

Thanks.

- Poonam

Re: Partial Sum in Straight Table

Mon, 14 Sep 2015 09:24:49 GMT

i think AGGR function will help you

Re: Partial Sum in Straight Table

tresB — Mon, 14 Sep 2015 09:30:24 GMT

Modify your expression to like:

=sum({<Id={"=Rank(Sum(Sal))<=$(vTopBooking)"}>}Sal)

And remove the limit max number from presentation tab.

Re: Partial Sum in Straight Table

Mon, 14 Sep 2015 09:35:22 GMT

Thanks a lot tresesco, It's working

Re: Partial Sum in Straight Table

Mon, 14 Sep 2015 09:36:15 GMT

Thank you so much everyone for helping me

Re: Partial Sum in Straight Table

avinashelite — Mon, 14 Sep 2015 09:41:29 GMT

if you have got the answer mark the correct answer and close this thread