topic Re: Set analysis with greater/less than or equal to a variable in QlikView

Set analysis with greater/less than or equal to a variable

Fri, 10 Oct 2014 16:00:04 GMT

Ok so this works:

sum({<[Lead time (days)] ={">=101 <=176"} >}[Lead time (days)])

I have a variable called LowerBound and another called UpperBound and they contain the following expressions:

fractile(total<Stock#> [Lead time (days)],$(Percentile_Min)) and fractile(total<Stock#> [Lead time (days)],$(Percentile_Max))

$(Percentile_Min) = 0.25

$(Percentile_Min) = 0.75

I want to replace the hardcoded values with either the variables $(LowerBound) and $(UpperBound) or the expressions they contain.

Currently I can get nothing to work

This doesn’t work:

sum({1<[Lead time (days)]= {'">=$(=fractile(total<Stock#> [Lead time (days)])"','">=$(=$(Percentile_Min)))"'}>*
<[Lead time (days)]= {'"<=$(=fractile(total<Stock#> [Lead time (days)])"','"<=$(=$(Percentile_Max)))"'}>}[Lead time (days)])

nor does this

=sum({1<[Lead time (days)]*={'$(UpperBound)'}>*<[Lead time (days)]/={'$(UpperBound)'}>}[Lead time (days)])

Please can you help?

Re: Set analysis with greater/less than or equal to a variable

Mon, 13 Oct 2014 07:29:02 GMT

anyone got any ideas - or do I need to give more detail?

Re: Set analysis with greater/less than or equal to a variable

mdmukramali — Mon, 13 Oct 2014 07:32:34 GMT

Dear ,

Can you share the sample file.

Thanks,

Mukram

Re: Set analysis with greater/less than or equal to a variable

Mon, 13 Oct 2014 07:34:40 GMT

Try this

sum({<[Lead time (days)]={">=$(=fractile(total<Stock#> [Lead time (days)],$(Percentile_Min))) <=$(=fractile(total<Stock#> [Lead time (days)],$(Percentile_Max)) )"}>}[Lead time (days)])

Re: Set analysis with greater/less than or equal to a variable

Mon, 13 Oct 2014 07:42:45 GMT

Thank you very much - this works like a dream.

As yet I haven't quite figured out when I should use " or ' and in what order the $ and >= need to be.

Oli