Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using Set Analysis in a chart, which works fine. according to a selected value,
the appropriate customers are taken into account in the chart.
But in a Listbox with the customers names, the irrelevant customers are not greyed.
My question is: how to reflect set analysis results in the linked dimensions?
Thanks!
The relevance of a field selection works when another field is selected. Set Analysis is used in expression and it calculates the result accordingly. No selection gets affected by set analysis, rather it behaves otherwise (and if you think a bit would find that - that is not logical also.) I think what you want is not wha you are writing. Your set analysis is not dynamic, you have defined that in expression during development and you would probably not want your selection status to be so (static).
Thanks.
Hi,
Well, using set analysis or rather indirect one, was the only choice, to reflect a dynamic value selection,
which involved 2 fields.
I'm quite sure that the user will demand now to see the customers which are taken into account by the set analysis,
not only in the chart, but also in the corresponding listbox.
Can you please share the logic you are using Set Analysis for? May be that will help address your problem.
Thanks.
Hi,
if we can elaborate on the famous example:
sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}
CompanyName)>} Sales)
assuming that we have an additional list box with the field CompanyName.
Would the customers that were not selected by the above set analysis (i.e., not purchased Baby Clothes) would be greyed?
Thanks!