Advanced Select in Field

[maleksafa]

Hi,

I have a button and i am using the action select in Field to exclude the stores that have a specific event.

my expression is the below:

=aggr(
	only
	(
	{<
	Store= E({<eventname={'Momentary Closing of the Shop'}>} Store)
	>} Store),Store)

so i am excluding the stores that have the eventname 'Momentary Closing of the Shops'

now this expression is working fine when used in any chart as a calculated dimension but not working when used in a button as 'select in field'

any idea?

[jpenuliar]

Hi Malek,

What is your Search String in the Action Property,

[nishit_shah]

Could you please share some screenshots ?

[maleksafa]

my Field is Store and my search string is the expression that i have posted

=aggr(
	only
	(
	{<
	Store= E({<eventname={'Momentary Closing of the Shop'}>} Store)
	>} Store),Store)

[jpenuliar]

is eventname a field? where your selecting the value "Momentary Closing of the Shop" ?

at button property>> Actions>> Select in Field >> Field : eventname ; Search string : Momentary Closing of the Shop

[jpenuliar]

then add another button Action: Select Excluded

[maleksafa]

i cannot simply do that, in fact the eventname is linked to date and store, and what i want to do is to exclude the stores that has this event. however not all the stores have events (regardless if it's momentary closing or not), so if i use the select excluded i will be in fact selecting all the events that are not 'Momentary' and by that i would have been excluding some stores that don't have events at all.