Set Analysis with bookmark and inputfield

[#1]

Hi All,

there is a table with 3 dims: SalesRep, ProductQty, Price. I'm looking for an expression that wil let me get intersection of current selection and bookmark, and be affected by inputfield change - in the below example "John" is a bookmark on John as a SalesRep.

Script:

---------

INPUTFIELD Price;

LOAD * Inline [

SalesRep, ProductQty, Price

John, 10, 7

Mary, 18, 5

];

Expression:

-----------------

SUM({$*John} ProductQty * Price)

Regards,

Przemek

[orital81]

Hi Przemek

You added an expression in your question :

Sum({$*John} ProductQty * Price)

Did you try it and it didn't work ?

[#3]

It doesn't - expresseion gets unaffected by price (inputfield) change.

[orital81]

Well, I tried it and it seems it is affected by Price Change

Look at my attached file

[#5]

Change the Price  to inputfield in the script and it'll stop.

INPUTFIELD Price;

LOAD * Inline [

SalesRep, ProductQty, Price

John, 10, 7

Mary, 18, 5

];

[orital81]

Still, It is Affected, Just press on the middle or left corner of the field, it will affect only when the field is Green.

[#7]

We are getting closer and closer 🙂 Change the value to e.g. 12 in the input field (not select) - it won't chane the value of the expression.

[orital81]

Got it now.

It seems like keeps the old value untill you choose it.

I have found a workarround :

Set Price Dimention as following :

If(SalesRep='John', Price, Null())

And Click the checkbox to Supress when it's Null

Hope this workarround is good for you.

[#9]

The workaround would work if there's few Reps - I got many 😞

[orital81]

Right...

If you add = before the Price Dimention it will work.

See my attachment.