topic Re: To Select Blank Value Using Trigger in QlikView

To Select Blank Value Using Trigger

Mon, 17 Feb 2014 10:49:11 GMT

Hi,

I have to select a set of values(including blank) in a particular field as default while leaving a sheet.

And I am using the following triggers

Select in Field:

Field: FIELD

Search String: only({<FIELD={"=len(FIELD)=0"} >}FIELD)

Toggle Select:

Field: FIELD

Search String: (Value1|Value2)

This works only if there is no selection on that FIELD. If there is any other selections, it is not working. Even I have tried 'Clear All Field' Trigger. But doesn't works.

Please help to find a solution.

Thanks & Regards,

Vinitha Mano R.

Re: To Select Blank Value Using Trigger

Mon, 17 Feb 2014 11:00:20 GMT

Are you really trying to clear the selections or select all the values in that field? Try changing the search string as *

Re: To Select Blank Value Using Trigger

sundarakumar — Mon, 17 Feb 2014 11:08:38 GMT

Hi Vinitha,

R u trying to do something ike document chaining?

Plese explain "doesn't work"...

-sundar

Re: To Select Blank Value Using Trigger

maxgro — Mon, 17 Feb 2014 11:55:22 GMT

if I understand I think you coulduse a trigger like that

select in field

field field

expression

=if(GetSelectedCount(field)>0,

'(' & concat(if(len(trim(field))>0, '"' & field & '"' ), '|') & '|""' & ')' ,

'(' & '""' & ')'

)

the idea is to create a search expression with the selected values (concat) and then add at the end the blank value

("firstselected"|"secondselected"|...........|"lastselected"|"")

see attachment

Re: To Select Blank Value Using Trigger

Mon, 17 Feb 2014 12:05:25 GMT

Hi,

Since the trigger with condition "only({<FIELD={"=len(FIELD)=0"} >}FIELD)" is working if there is no selections on that field, I have tried to apply 'Clear field' trigger before applying "select in Field" trigger.

But even then the blank value is not selected if I leave the page but the other 2 values which I have mentioned in 'Toggle Select' trigger is selected.

Now I would like to select the 2 values along with the blank value when I leave the page.

Kindly help.

Thanks & Regards,

Vinitha Mano R.

Re: To Select Blank Value Using Trigger

Mon, 17 Feb 2014 12:12:48 GMT

Can you attach a sample because I don't know the 2 values you are trying to select when you leave the page.

Re: To Select Blank Value Using Trigger

Mon, 17 Feb 2014 12:27:12 GMT

find below an example where I could select two values along with the blank

("b"|"f"|"")

Try it after changing your intended values

Re: Re: To Select Blank Value Using Trigger

Mon, 17 Feb 2014 12:38:03 GMT

Hi,

I have attached the sample.

Kindly help.

Thanks & Regards,

Vinitha Mano R.

Re: Re: Re: To Select Blank Value Using Trigger

Mon, 17 Feb 2014 12:45:32 GMT

Thanks for the sample.

Please check the triggers in sheet properties onActivateSheet for the selection when entering the sheet and OnLeaveSheet for the selection when leaving the sheet.

Regards,

Sajeevan

Re: Re: To Select Blank Value Using Trigger

Tue, 18 Feb 2014 05:59:49 GMT

Hi,

Thank you for your help. It works fine.

Thanks & Regards,

Vinitha Mano R.

Re: Re: To Select Blank Value Using Trigger

Tue, 18 Feb 2014 06:03:49 GMT

Thanks for the update. Please mark this as resolved.

Regards,

Sajeevan