topic Re: Advanced Select in Field in QlikView

Advanced Select in Field

maleksafa — Thu, 26 Mar 2015 15:28:58 GMT

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?

Re: Advanced Select in Field

jpenuliar — Thu, 26 Mar 2015 15:45:14 GMT

Hi Malek,

What is your Search String in the Action Property,

Re: Advanced Select in Field

nishit_shah — Thu, 26 Mar 2015 15:50:43 GMT

Could you please share some screenshots ?

Re: Advanced Select in Field

maleksafa — Thu, 26 Mar 2015 16:00:16 GMT

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)

Re: Advanced Select in Field

jpenuliar — Thu, 26 Mar 2015 16:21:37 GMT

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

Re: Advanced Select in Field

jpenuliar — Thu, 26 Mar 2015 16:22:33 GMT

then add another button Action: Select Excluded

Re: Advanced Select in Field

maleksafa — Fri, 27 Mar 2015 09:10:02 GMT

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.