Can I use an if in a "Select in field" Action on the field value?

[#1]

I like to use an if statement in a button "select in field" action.

So in the field i now have:

if (pctypeid='2',pnTable,pcTable)

So depending on the value of pctypeid, I like to do a select/search on the pnTable or the pcTable.

The "Search String" of the action is a value I entered in a variable.

Thanks in advance.

[brenner_martina]

Hi, Stormy,

of course you can use an if-.statement, it must begin with "=":

=if (pctypeid='2',pnTable,pcTable)

Greetings from Munich

Martina

EVACO GmbH

[Miguel_Angel_Baeyens]

Hi,

Indeed, any time you see the [...] button at the side of a text dialog means that it allows expressions. Check the attached application.

Hope that helps.

Miguel

[#4]

I have tried that, but does not seem to work.

This is how it now looks.

It just does not do a sub select.

[#5]

I cannot open your example, as I am still using the personal edition. (My work is still in discusion to buy a developer version)

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

It's very simple, this is the script:

Data:
LOAD * INLINE [
Name, Address
AAA, AA-AAA
BBB, BB-BBB
AAA, BB-BBB
BBB, AA-AAA
];
Code:
LOAD * INLINE [
Code
1
2
3
4
];

And the button as an action that has Select in Field

=If(Even(Code), 'Address', 'Name')

And Search String

='*' & vSearchFor & '*'

If values 2 or 4 are selected in Code, the button will search for values starting with the value stored in the variable vSearchFor in the field Address, otherwise, search the same string but in the field Name. Two considerations worth mentioning:

1. Obviously, this can be refined as much as you want, using a conditional in the search string as well
2. Obviously, if the field where you are doing selections is in a table linked to the rest of the data model, the button may have no effect, since QlikView selects all possible values regardless where the selection is made.

Hope that helps.

Miguel

[#7]

Thanks, I had the table/field not in quotes.