I have one field called "User Agent", in that I need to exclude the field values "Bots","Spider". I have added button to exclude this values.
Now my requirement is when am excluding these values, other list boxes values also excluding. But it should not exclude.
For Ex:Before Exclude the User agent field values Bots, Spider, Jobboard field having 8 jobboards. After we excluding User Agent field values, Jobboard is reducing to 6 jobboards.
But in list box it should not be reduced after we exclude User agent field values. Can anyone please help me how yo solve this?
Thanks for your reply.
I am using button to exclude User Agent field values "Bot", "Spider","Typhoeus".
Before we exclude this User Agent values, 13 Jobboard possible values it is showing (as per below screenshot)
After we excluding the User Agent values "Bot", SPider", Typhoeous" , 10 Jobboards it is showing because remaining 3 jobboards are associated with User Agent excluding values, so when we are excluding those user Agent values jobboard also excluding. But I dont want to exclude the jobboards.
I guess you meant 'greyed out' by excluded (JobBoard - members). If so, it is so by qv design, unassociated values would be greyed out. You can highlight them to consider as alternative values by - listbox->General tab->check 'Show alternatives'.
I din mean that. As per second screenshot after excluding , total jobboards are 10. Before exclude , total jobboards are 13 (Yo can see in list box screenshot).
After exclude it should not reduce 13 to 10 jobboards. It should show 13 jobboards.
with your button you exclude the three values globally. Why not exclude these values in the list box of the field User Agent, only. Use the expression in this listbox with an If statement...
If ([User Agent] <> 'Bot' or [User Agent] <> 'Spider' or [User Agent] <> 'typhoeus', [User Agent])
This act like a calculated dimension for this listbox and does not exclude the above values for other charts or list boxes.
Hope this helps