01-09-2018 08:48 PM
this is a bit of a random question.
I am interested in selecting the data that is displayed in a graph using lists. Because this list, have several levels, in the ideal world the user could use something like this:
However, I do not think SAS VA currently allows for this.
So far I have two alternatives.
1- Multiple lists one for each level. It just gets a bit messy for the user to know what value is within each level.
2- Cross tab and hierarchy. This way the user can drill down to the different levels and by clicking in the number (measure), the filter will be activated. Although, this produce somehow the outcome, it would ideal to have something prettier, clear and easier to use (particular when you want to select multiple values within different levels of a list).
As I said, it is a bit of a random request.
01-10-2018 03:42 AM
I would go for the first one with multiple lists, one for each level and create interactions between them so that the sublists filters due to the selections in the lists above.
I have tried the cross tab, but as you say it a bit clumsy to use just for selection of the data.