topic Re: ACTION TO SELECT A SPECIFIC FIELD in QlikView

ACTION TO SELECT A SPECIFIC FIELD

Tue, 22 Apr 2014 19:10:21 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:14:09 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:19:29 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

Wed, 23 Apr 2014 14:03:39 GMT

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.

Re: ACTION TO SELECT A SPECIFIC FIELD

MK_QSL — Wed, 23 Apr 2014 14:06:46 GMT

Search String

(Q1|Q2)

Re: ACTION TO SELECT A SPECIFIC FIELD

Sat, 26 Apr 2014 18:52:13 GMT

Thanks Manish!

topic Re: ACTION TO SELECT A SPECIFIC FIELD in QlikView

ACTION TO SELECT A SPECIFIC FIELD

P.S: Apologies for my level of English

Re: ACTION TO SELECT A SPECIFIC FIELD

Re: ACTION TO SELECT A SPECIFIC FIELD

Re: ACTION TO SELECT A SPECIFIC FIELD

Re: ACTION TO SELECT A SPECIFIC FIELD

Re: ACTION TO SELECT A SPECIFIC FIELD