Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is what I want to do and I am not sure if it is possible using Alternate states or any other way.
I have two charts and one straight table in my dashboard.
I have a filter that I only want to work with the table. But I need the table to work with the other filters and the charts.
I tried setting alternate states and I can make the table work with the filter. But then it doesn't respond to any other changes.
I guess my question is can an object have multiple states or is there another way to do this?
Instead of using alternate states in this case, I would use set analysis on the charts, so that they won't be affected by the selections on the filter.
Let's say that your filter is called 'Country'.
Then on each of the charts I would add "Country=" in the set analysis.
Example: sum({<Country=>}Sales)
This way the charts will respond to everything except your filter and table will still be affected by the filter (and the rest of the other selections).
Hope this helps.
Kind regards,
Nuno
I do not think that alternate state can achieve this.
So the logic is to use set analysis to disable a field or filter selection on an object
Let there be 3 filters
Brand,Location,Store
Now you want Brand and location to be selectable for the for the all three objects but Store not for the straight table.
So let straight table have expression sum(Sales)
then write it as
=sum({<Store=->} Sales)