Trying to indicate <= numeric variable in Set Analysis

almalecha — Fri, 11 Sep 2015 14:22:50 GMT

Hello,

I've created a variable vTopBoxScore, and intentionally left the '=' out so it will calculate per row in my pivot table.

NUM((SUM([TB MO Number Indicator NBR]) / Count([TB MO Case ID])) * 100, '##.#'))

In an expression within the pivot table then, I would then like to show a max benchmarking score that is less than or equal to the variable. I've tried the sytnax below, but it isn't returning anything.

=MAX({$<[TB Overall BR Benchmark Score Amount] = {"<=$(vTopBoxScore)"}>} [TB Overall BR Benchmark Score Amount])

I've also tried changing the dollar sign expansion to the below, but then it seems to always return the max benchmarking score, and ignore the set analysis all together.

=MAX({$<[TB Overall BR Benchmark Score Amount] = {"<=$($vTopBoxScore)"}>} [TB Overall BR Benchmark Score Amount])

Is there perhaps a different way I should be using the dollar sign expansion, or a different syntax in the expression? Any help would be greatly appreciated.

Thank you,

Amy

Re: Trying to indicate <= numeric variable in Set Analysis

m_woolf — Fri, 11 Sep 2015 14:31:55 GMT

You vTopBoxScore variable has mismatched parentheses

Re: Trying to indicate <= numeric variable in Set Analysis

almalecha — Fri, 11 Sep 2015 14:35:52 GMT

Ah, sorry, I missed a parentheses when I copied and pasted into my post.

The variable looks like this:

(NUM((SUM([TB MO Number Indicator NBR]) / Count([TB MO Case ID])) * 100, '##.#'))

topic Trying to indicate <= numeric variable in Set Analysis in QlikView

Trying to indicate <= numeric variable in Set Analysis

Re: Trying to indicate <= numeric variable in Set Analysis

Re: Trying to indicate <= numeric variable in Set Analysis