Set Analysis with bookmark and inputfield - Page 2 - Qlik Community

Report Inappropriate Content · ‎2012-01-30

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

Report Inappropriate Content · ‎2012-01-30

No attachment...

orital81 · ‎2012-01-30

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

//

Report Inappropriate Content · ‎2012-01-30

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

orital81 · ‎2012-01-30

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)

Report Inappropriate Content · ‎2012-01-30

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!

Report Inappropriate Content · ‎2012-01-30

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

orital81 · ‎2012-01-30

No Problem.

Good Luck