I have an expression that i have some set analysis that uses a variable.
The variable is dynamically populated based on a field the user makes selections on.
I need these seletions to be applied to a field in the set analysis.
so basiaclly, the data has a 'Type' field which contains
I then have a data island that has the following
Type_Selection << field name
Base + Overlay
when i select Bud or Base, this works as it only selects Bud or Base in the Type field.
but when i select Base + Overlay, this relates to 2 of the types, so i need the set analysis to consider both Base and Overlay in the type field.
I have attached a simple sample, could anyone take a look please?
I know i can link the Type_Selection field to the Type which will work but the problem this causes is it affects the rest of the data and returns incorrect values. So linking would mean that i would have top add in some set analysis to over 100 expressions throughout the QVW to ignore the Type field.
Which is why i am looking to get the set analysis/variable option working instead.