Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
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,

Thanks in Advance..

1 Solution

Accepted Solutions
Highlighted

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%')

View solution in original post

5 Replies
Highlighted

Re: select Range

I am not sure I follow your requirement. Can you elaborate?

Highlighted

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%')

View solution in original post

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

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

Re: select Range

Thank you sunny..

It's really very helpful....