Solved: Using USERSETTINGS to filter a Slice - Page 2

gcor71 · 07-24-2023 09:44 AM

You find a man defeated.

I am trying to define a Slice of my TRACK_ACTIVITIES table, using a value from USERSETTINGS(Track).

Nothing I do returns a slice with any content. What (horribly obvious thing) have I overlooked?

The only thing I can think of - but don't know how to check - is that USERSETTINGS(Track) is a dependent lookup in the User Settings form (see image). I think/hope the Track value returned in the UI Form, based on preceding choices of Group and Section, is saved into USERSETTINGS and not just recalculated in the UI?

Pointers and suggestions gratefully received.

Marc_Dillon

You could change your slice expression to:

OR( ISBLANK([_THISUSER].[track]) , [track]=[_THISUSER].[track] )

View solution in original post