Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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..
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
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.
Search String
(Q1|Q2)
Thanks Manish!