# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Did you mean:
Highlighted
Creator II

## Partial sum based on rank

i have attached a QVD (kindly refer it ) in that i want to display the rank for top 5 and followed and partial sum for both and sum for others

input

and i want to display like this

1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Partial sum based on rank

Further enhancements

7 Replies
Highlighted
MVP

## Re: Partial sum based on rank

Something like this?

Highlighted
Creator II

## Re: Partial sum based on rank

yes like that only, but here in your result i can see the order of the rank has been changed also i want to display the rank in one column as i shown in excel screenshot

Highlighted
MVP

Here you go

Highlighted
MVP

## Re: Partial sum based on rank

Further enhancements

Highlighted
Creator II

# It Worked,

at first thanks a lot,

No one cannot unveil this type of riddle, unless its Sunny,

i replaced my column names in that query and its worked like charm,

but it will take some decades to understand whats going on inside that query,

its not a query its sorcery.

Many thanks

Highlighted
Creator II

## Re: Partial sum based on rank

Hi sunny everything fine for the values i gave but i have to get some for an another column which is showing the same sum for every 5

attached the file and Screen shot for reference,

kindly help this out to find, thank you in advance

in this i want the sum of s2 column to be proper for every 5

Highlighted
MVP

## Re: Partial sum based on rank

This?

Expression:

Pick(Dim,

Sum(s2),

Sum({<Name = {"=Rank(Sum(Sales)/Sum(TOTAL Sales)) < 6"}>} s2),

Sum(s2),

Sum({<Name = {"=Rank(Sum(Sales)/Sum(TOTAL Sales)) >= 6 and Rank(Sum(Sales)/Sum(TOTAL Sales)) < 11"}>} s2),

Sum({<Name = {"=Rank(Sum(Sales)/Sum(TOTAL Sales)) >= 11"}>} s2))