ACTION TO SELECT A SPECIFIC FIELD

[#1]

I´m pretty sure my question has an easy solution. I would be very grateful
if any of you could help me.

I will try to explain easily what I want to do:

I want to allow the analysis only for the first and second quarter of the
year however, if I include a list box, the four quarters are available to be
selected. It would be ideal to implement a text box with an action wich select
the first quarter and another one wich select the second quarter. Is it
possible? Is there a better option?

I look forward to your suggestions.

1. P.S: Apologies for my level of English

                                

[MK_QSL]

You can also make List Box with expression as below

Considering that four quarters are Q1, Q2, Q3 and Q4

Write below in List Box Expression

=IF(Match(Quarter,'Q1','Q2'), Quarter)

or

IF(Quarter = 'Q1' or Quarter = 'Q2', Quarter)

=================================

Using Text Box

Create a Text Box

Write Q1 in Text

Actions >> ADD >> Selection >> Select in Field >>

Field

Quarter

Search String

Q1

or

='Q1'

same as for Q2

Hope this helps..

[pgrenier]

Hello Cristina,

You could accomplish this using buttons that have a single action: Select in Field with the value Q1 or Q2 in the Quarter field.

Then, if you wish, you may hide the Listbox so that your users don't modify it's value.

Please find attached an example QVW file.

Regards,

Philippe

[#4]

Manish,

How can I do if I want to select the two quarters at once? I mean, I want to make a third list box wich select Q1 and Q2 at the same time.

I´ve tried to write ="Q1" and "Q2" but it doesn´t work.

Thanks a lot again.

[MK_QSL]

Search String

(Q1|Q2)

[#6]

Thanks Manish!