Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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
Bud
Base
Overlay
I then have a data island that has the following
Type_Selection << field name
Bud,
Base,
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.
any help would be appreiated
Hi, Chris. Maybe this
Hi, Chris. Maybe this
See if the below helps:
Change your below expression:
Sum({<Type={"($(vBudgetType)))"}>}Value)
To
IF(GetFieldSelections(TypeSelect)='Base + Overlay',Sum({<Type={'Base','Overlay'}>}Value),Sum({<Type={"($(vBudgetType)))"}>}Value))