topic Re: select Range in QlikView

Range Selection

Nagaraju_KCS — Wed, 25 Nov 2020 16:16:04 GMT

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..

Re: select Range

sunny_talwar — Thu, 21 Apr 2016 20:52:54 GMT

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

Re: select Range

sunny_talwar — Fri, 22 Apr 2016 02:35:27 GMT

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

Re: select Range

Nagaraju_KCS — Fri, 22 Apr 2016 02:51:28 GMT

Thank you so much...

Actually in my real data my dimension Calculated dimension

if i am use that dimension.

will it works???

Re: select Range

sunny_talwar — Fri, 22 Apr 2016 02:53:37 GMT

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

Re: select Range

Nagaraju_KCS — Sat, 23 Apr 2016 04:53:26 GMT

Thank you sunny..

It's really very helpful....