Using dynamic formula in Action:select in Field

[#1]

Hello Guys,

Have this question:

In excel you can filter the data based on a range. In Qlikview there is no function for that, so I am trying to build a workaround.

1st step:

So I got some formulas, and I load them in my inline table:

Load * inline [

SelectionFieldName, Formula

2016 No Visits,"sum({<YEAR={'2016'}>} NV)"

2016 Member Count,"sum({<YEAR={'2016'}>} MM)"

]

So they work in text boxes, if I pick a Selection Field Name. See below:

Now the second step: I want to pick and choose a certain field, PCP_No in my case, based on the formula and the variable. The following works, as if I click on it it gives me a list of PCPs that satisfy the criteria. See pic below:

But here is the problem: Ideally I want this to work based on the Field I choose, kind like combining the previous 2 steps.

No success. I think single quotes and double quotes might be the issue, but I tried different combos and so far no luck.

See below:

If you have any idea, that will be great. Thank you.

I upload the test qvw.

[swuehl · Accepted solution]

I think you are right, you need to take care of the quoting.

Either remove the single quotes from the set modifier, as far as possible, or use something like

='=if(aggr('& Formula&',PCP_No)> $(v_Operation1), PCP_No)'

[#3]

Magical. Thank you!

Now the users can filter the data. This will be great!