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.

P.S: Apologies for my level of English

[MK_QSL · Accepted solution]

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]

It has been really helpfull.

Thanks a lot Philippe!

[#5]

Thank you very much, Manish!!

I´ve already did what you suggested and...It worked!!!