Table slice by user settings.
I use usersettings as filter to slice the table.
Usersettings has Ref type, and user select items to custom filter to show some views.
What the problem is when the usersetttings is left untouched (or none is selected) we could not pick up any row out of table. What i wish to do is to show all if none of usersetting is selected.
I tried to use IF expression like IF(ISNOTBLANK(USERSETTINGS(XXX)), USERSETTINGS(xxxxx), “”), but this expression didnt work.
How can we achieve this?