topic Automatically Select Other Field based on Certain Selection in QlikView

Automatically Select Other Field based on Certain Selection

Thu, 26 Jan 2012 02:36:49 GMT

Hi Guys,

I have this logic that I wanted to automatically select other fields when I make a selection on other fields, please see below:

1. Date_Store1 ex. '20/10/2011'

2. Date_Store2 ex. '20/10/2011'

3. Date_Store1 ex. '20/11/2011'

4. Date_Store2 ex. '25/11/2011'

All the above fields are no connection to each other completely no link, separate table.

What I want to do is to create a field called Date_Month, Date_Year:

Date_Month = 1,2,3,4..12

Date_Year = 2011,2012

Now, upon selecting values from this field all dates from different Store should be selected as well.

Ex. If i select:

10 from Date_Month only rows 1 and 2 should be showed while hiding the other two

11 from Date_Month only rows 3 and 4 should be showed while hiding the other two

same as with year

Regards,

~skip

Oleg_Troyansky — Thu, 26 Jan 2012 03:27:18 GMT

You can create an Action and trigger it off the selection in a certain field. Open Document Properties, tab "Triggers".

Wed, 07 Mar 2012 07:41:07 GMT

I was going to say 'duh'...but decided not to...oh...just did...

.....but you didn't answer his question.

Can you go elaborate:

In the trigger you have OnSelect / OnChange triggers..

When openeing the trigger OnSelect you have Add Action...

Once you click the "Select" action, you have

"Select In Field", "Select Possible"...

I suspect the answer is "Select in Field"...I tried that...

When adding that trigger it asked me for a "field" name...I type the name of the field that I want to select..

Seem simple enough...but doesn't work.

So, maybe a bit more explaination would help?