Discussion board where members can get started with QlikView.
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.
Thanks in Advance..
Try this expression:
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(vMin='--Select--' or vMax='--Select--', Sum(OrderSalesAmount),
Sum(OrderSalesAmount)))), Category)), '#0.00%')
View solution in original post
I am not sure I follow your requirement. Can you elaborate?
Thank you so much...
Actually in my real data my dimension Calculated dimension
if i am use that dimension.
will it works???
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
Thank you sunny..
It's really very helpful....