topic Set Analysis with bookmark and inputfield in QlikView

Set Analysis with bookmark and inputfield

Mon, 30 Jan 2012 09:12:58 GMT

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

Set Analysis with bookmark and inputfield

orital81 — Mon, 30 Jan 2012 09:24:16 GMT

Hi Przemek

You added an expression in your question :

Sum({$*John} ProductQty * Price)

Did you try it and it didn't work ?

Set Analysis with bookmark and inputfield

Mon, 30 Jan 2012 09:28:41 GMT

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

Re: Set Analysis with bookmark and inputfield

orital81 — Mon, 30 Jan 2012 10:22:20 GMT

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

Look at my attached file

Set Analysis with bookmark and inputfield

Mon, 30 Jan 2012 10:28:46 GMT

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

];

Re: Set Analysis with bookmark and inputfield

orital81 — Mon, 30 Jan 2012 10:36:54 GMT

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

Set Analysis with bookmark and inputfield

Mon, 30 Jan 2012 10:43:09 GMT

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.

Re: Set Analysis with bookmark and inputfield

orital81 — Mon, 30 Jan 2012 11:04:27 GMT

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.

Set Analysis with bookmark and inputfield

Mon, 30 Jan 2012 11:16:29 GMT

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

Re: Set Analysis with bookmark and inputfield

orital81 — Mon, 30 Jan 2012 11:36:29 GMT

Right...

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

See my attachment.

Set Analysis with bookmark and inputfield

Mon, 30 Jan 2012 11:37:33 GMT

No attachment...

Re: Set Analysis with bookmark and inputfield

orital81 — Mon, 30 Jan 2012 11:38:58 GMT

I attached it after I have eddited the last comment.

Note that you will need a coment bellow the =Price.

Otherwise it wont work.

=Price

Set Analysis with bookmark and inputfield

Mon, 30 Jan 2012 11:54:55 GMT

My pivot cannot show price thus I'll need to look for a different solution. Anyway, I don't get why the expression doesn't wotk without the inactive comment...

Set Analysis with bookmark and inputfield

orital81 — Mon, 30 Jan 2012 12:00:42 GMT

I know, it's wierd. but that's the only way it works (inactive comment).

Could be some bug in the program.

Anyway, If you don't want to show price you can set it's column length to minimum

and set the text color to white (workarround to make pivot table column invisable)

Re: Set Analysis with bookmark and inputfield

Mon, 30 Jan 2012 12:10:49 GMT

Probably, a bug. The problem is I got many prices and many reps so would get hundreds of records and the pivot has to be synthetic. I'll restart the discussion - maybe somebody will come up with the final solution. Many thanks for your help!

Re: Set Analysis with bookmark and inputfield

Mon, 30 Jan 2012 12:14:49 GMT

Anyone any idea, please? We can't get the final solution yet.

Set Analysis with bookmark and inputfield

orital81 — Mon, 30 Jan 2012 12:21:27 GMT

No Problem.

Good Luck