topic Re: Sheet Trigers in QlikView

Sheet Trigers

Thu, 27 Sep 2012 17:53:00 GMT

I have a filter/ Multibox called "Subscriber Type" having following values:

Digital

Digital + Print

Non Subscriber

Now I am trying to create an action/triger that when I open the sheet that filter should by default select "Digital" every time.

To get this I am doing followings:

Sheet properties >> Trigers >> OnActiviteSheet Add Actions >> Select in Field >> Select Field is "= [Subscriber Type]" and String is "= 'Digital'

but it is not working and not selecting Digital in the filter.

Am I doing something wrong here?

Plesae advise?

Thanks,

Re: Sheet Trigers

MayilVahanan — Thu, 27 Sep 2012 18:13:13 GMT

Try like this

Setting->Document properties -> trigger -> onopen -> Action type:selection ->selection in field

Re: Sheet Trigers

Thu, 27 Sep 2012 18:15:41 GMT

This is what I am doing.

Can you write how to specify the field name and Search String?

Re: Sheet Trigers

MayilVahanan — Thu, 27 Sep 2012 18:21:54 GMT

Do like this

Selection in field :[Subscriber Type]

Search string: = 'Digital'

Re: Sheet Trigers

Thu, 27 Sep 2012 19:39:08 GMT

This is what I am using but not getting the desired result.

Re: Sheet Trigers

MayilVahanan — Thu, 27 Sep 2012 19:55:55 GMT

can you post a sample file?

Re: Sheet Trigers

Thu, 27 Sep 2012 20:26:01 GMT

remove the = from the field name.

Re: Sheet Trigers

Thu, 27 Sep 2012 20:31:52 GMT

I have attached a sample file. Please create a by default filter from multibox which should be pre selected automatically when app is launched. Thanks,

Re: Sheet Trigers

MayilVahanan — Thu, 27 Sep 2012 20:38:06 GMT

Please check the attached file now..

Hope that helps

Re: Sheet Trigers

Thu, 27 Sep 2012 20:41:55 GMT

That was perfect. Thanks a lot.

Here is one more questions though. Is it possible to define which sheet should open first by default when a qv document is open every time?

If yes how can I do that?

Thanks,

Re: Sheet Trigers

Thu, 27 Sep 2012 20:44:09 GMT

Save the file in the position you want it opened in.

This includes selections, positions, sheet opened, containers selected.

Everything.

Re: Sheet Trigers

MayilVahanan — Thu, 27 Sep 2012 20:54:49 GMT

Use Open Trigger in Document propeties -> Active sheet -> give sheetID

Hope that helps

Re: Sheet Trigers

Fri, 28 Sep 2012 20:08:08 GMT

Hi,

How can I add more than two values to select from a field when sheet is activited?

I am trying to select both 'Print' and 'Print + Digital' to be selected when sheet is activited.

I am wring like this:

='Print, Print + Digital'

Am I doning some thing wrong here?

Re: Sheet Trigers

MayilVahanan — Fri, 28 Sep 2012 20:22:38 GMT

Try like this

vTest is a variable, use vTest , value: 'Print, Print + Digital'

And use it in the search string

='('&replace(vTest,',','|')&')'

Re: Sheet Trigers

Fri, 28 Sep 2012 20:27:12 GMT

I dont have qv open but to make a second selection use the trigger option

directly below select in field as many times as you want.

This puts it into current selection box exactly like it would if you

naturally selected them.

On Sep 28, 2012 4:22 PM, "Mayil Vahanan Ramasamy" <qcwebmaster@qlik.com>

Re: Sheet Trigers

Fri, 28 Sep 2012 20:47:28 GMT

Hi Ramasamy,

Can you please attached a sample qvw?

I am sorry I didn't get your explanation 😞

Re: Sheet Trigers

Fri, 28 Sep 2012 20:55:42 GMT

I dont have qv open but to make a second selection use the trigger option directly below select in field as many times as you want.

select in field must be first. then the option right below it as many times as you want.

This puts it into current selection box exactly like it would if you naturally selected them.

Re: Sheet Trigers

MayilVahanan — Fri, 28 Sep 2012 20:57:09 GMT

On open the file ,it selects the digital and digital+printer option, please see the attached file

Hope that helps

Re: Sheet Trigers

Fri, 28 Sep 2012 21:18:00 GMT

Ramasamy, Thanks for your video but I created same variable and tried to used it but I did not work for me.

And one more questions please. I have list of IP address and I want to select first 1000 in the list. How Can I make selection for first 1000 IP Address?

Thanks,

Re: Sheet Trigers

MayilVahanan — Fri, 28 Sep 2012 21:30:00 GMT

In script you can use first 1000 Load * from tablename

=if(Aggr(Rank(IP),IP) < 1000, IP) in list box expression