Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Using dynamic formula in Action:select in Field

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:

1.jpg

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:

2.jpg

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:

3.jpg

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

I upload the test qvw.

1 Solution

Accepted Solutions
MVP
MVP

Re: Using dynamic formula in Action:select in Field

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)'

View solution in original post

2 Replies
MVP
MVP

Re: Using dynamic formula in Action:select in Field

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)'

View solution in original post

Not applicable

Re: Using dynamic formula in Action:select in Field

Magical. Thank you!

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