topic Re: Actions - Select in Field in QlikView

Actions - Select in Field

Wed, 06 Nov 2013 10:37:02 GMT

Hey Guys

Can you answer, I have a Landing page that I want to navigate to another sheet and select multiple values in multiple charts.

I have managed to get it to select values in one of the charts, but not the other.

Is there any restriction on the number of actions with the Select In Field action?

Can you for example ..

Activiate Sheet

Select Object
Select In Field
Select Object (a different object on the same sheet)
Select In Field
Select Object (a different object on the same sheet)
Select In Field

I cant get this to work, should it?

Thanks

John

Re: Actions - Select in Field

jerrysvensson — Wed, 06 Nov 2013 10:46:00 GMT

I can't get Select in field to work with multiple values. It should be possible according to the help file.

Can you give more details on what you want to achieve?

Re: Actions - Select in Field

jonathandienst — Wed, 06 Nov 2013 10:52:46 GMT

Qlikview selections do not reside in charts, they are applied globally to the data model (although alternate states do provide a way around this). So "selecting" objects would play no role in what I think you are trying to achieve.

If you are trying to make 3 different selections in the 3 charts, you could either use set analysis (if the 3 selections are known in advance), or use one alternate state for each chart (if the users need to be able to change the selections).

For alternate states solution, you would either need three list boxes to make the selections in each of the states, or you could use some logic to display a single list box and some action to copy the selections to the states. (Although actions do not fully support alternate states yet).

HTH

Jonathan

Re: Actions - Select in Field

christian77 — Wed, 06 Nov 2013 10:57:11 GMT

Hi:

If you want to select in field Country, for example UK, you use Select in field. Let's say that you want to add France to the actual selection. If you choose select in field, it'll deselect UK and then select France. So, for the 2nd selection you must use Alternate Select, which means add the selection.

Remember that selections in fields are for the whole document, not just for some objects. If you want to limit dimensions in charts, use dimension limits or calculated dimensions. You cannot select France for a chart and UK for another chart, at least you are using alternate states but that’s another movie.

For the objects I think it should be Activate Object, Maximize, Minimize and Restore but I don't see them any more since version 9 or 10. I don't know if they are available any longer.

I don't remember any limitation in the number of actions per Qlik or button.

Re: Actions - Select in Field

Wed, 06 Nov 2013 12:02:19 GMT

Does this mean that when you use 'Select In Field', that you dont need to pick an object, just a field in the underlying dataset?

Thanks

Re: Actions - Select in Field

tresB — Wed, 06 Nov 2013 12:06:30 GMT

Yes, you are right. As the action says 'Select In Field' , it doesn't require an object apart from the field you mention.

Re: Actions - Select in Field

Wed, 06 Nov 2013 12:11:35 GMT

Ok, that all makes sense.

The issue I am having is with a field loaded from "MonthName(PostingDate) As Posting_PRD", which is showing in the table as Oct 2013.

I am trying to get it to select that based on a variable I have created called vMaxOfInvoiceDate.

So I am using Select In Field, Field = Posting_PRD, Value = vMaxOfInvoiceDate.

But this is not working, any ideas?

Thanks

Re: Actions - Select in Field

jonathandienst — Wed, 06 Nov 2013 12:15:37 GMT

Depending on how you defined the variable, you may need $(vMaxOfInvoiceDate)

Re: Actions - Select in Field

christian77 — Wed, 06 Nov 2013 12:15:53 GMT

Hi.

You want this variable to be evaluated in the var panel. Place an equal sign in the var panel.

vMaxDate = max(Date)

Also be careful with formats. It should work.

When in the action form, write the field with no equal sign and the variable with an equal sign

Salutes.

Re: Actions - Select in Field

Wed, 06 Nov 2013 17:59:22 GMT

Thanks Christian, that got it