topic ACTION TO SELECT A SPECIFIC FIELD in QlikView

ACTION TO SELECT A SPECIFIC FIELD

Tue, 22 Apr 2014 19:06:42 GMT

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

Re: ACTION TO SELECT A SPECIFIC FIELD

MK_QSL — Tue, 22 Apr 2014 19:17:36 GMT

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)

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'

same as for Q2

Hope this helps..

Re: ACTION TO SELECT A SPECIFIC FIELD

pgrenier — Tue, 22 Apr 2014 19:18:05 GMT

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

Re: ACTION TO SELECT A SPECIFIC FIELD

Tue, 22 Apr 2014 19:29:50 GMT

It has been really helpfull.

Thanks a lot Philippe!

Re: ACTION TO SELECT A SPECIFIC FIELD

Tue, 22 Apr 2014 19:31:10 GMT

Thank you very much, Manish!!

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