# 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 Specialist II

## Range Selection

Hi All,

I have developed one report, based on select ranges..

Here not showing Total Contribution %, I have to show Contribution % and Based on top selection.. it should be change the %

If I am clear range, it should be top5 records.

PFA,

1 Solution

Accepted Solutions
Highlighted MVP

## Re: select Range

Try this expression:

Num(1 -

Sum(Aggr(If(Rank(If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),

If(Sum(LineSalesAmount)>=\$(vMin) and Sum(LineSalesAmount)<=\$(vMax),

Sum(LineSalesAmount)))) <= \$(vTop),

If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),

If(Sum(LineSalesAmount)>=\$(vMin) and Sum(LineSalesAmount)<=\$(vMax),

Sum(LineSalesAmount)))), Category))/

Sum(Aggr(If(Rank(If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),

If(Sum(LineSalesAmount)>=\$(vMin) and Sum(LineSalesAmount)<=\$(vMax),

Sum(LineSalesAmount)))) <= \$(vTop),

If(vMin='--Select--' or vMax='--Select--', Sum(OrderSalesAmount),

If(Sum(LineSalesAmount)>=\$(vMin) and Sum(LineSalesAmount)<=\$(vMax),

Sum(OrderSalesAmount)))), Category)), '#0.00%')

5 Replies
Highlighted MVP

## Re: select Range

Highlighted MVP

## Re: select Range

Try this expression:

Num(1 -

Sum(Aggr(If(Rank(If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),

If(Sum(LineSalesAmount)>=\$(vMin) and Sum(LineSalesAmount)<=\$(vMax),

Sum(LineSalesAmount)))) <= \$(vTop),

If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),

If(Sum(LineSalesAmount)>=\$(vMin) and Sum(LineSalesAmount)<=\$(vMax),

Sum(LineSalesAmount)))), Category))/

Sum(Aggr(If(Rank(If(vMin='--Select--' or vMax='--Select--', Sum(LineSalesAmount),

If(Sum(LineSalesAmount)>=\$(vMin) and Sum(LineSalesAmount)<=\$(vMax),

Sum(LineSalesAmount)))) <= \$(vTop),

If(vMin='--Select--' or vMax='--Select--', Sum(OrderSalesAmount),

If(Sum(LineSalesAmount)>=\$(vMin) and Sum(LineSalesAmount)<=\$(vMax),

Sum(OrderSalesAmount)))), Category)), '#0.00%')

Highlighted Specialist II

## Re: select Range

Thank you so much...

Actually in my real data  my dimension Calculated dimension

if i am use that dimension.

will it works???

Highlighted MVP

## Re: select Range

Nope, try with both Product and Category without the if statement

UPDATE: If this doesn't work, then I propose calculating this if statement in the script and call it Dimension (maybe) and then use Dimension as your dimension and use that in the Aggr() function also

Highlighted Specialist II

## Re: select Range

Thank you sunny..