Urgent Help Required

[vikasmahajan]

Hi Team,

I have data model with multiple facts using  qualify and unqualify  for eg   nonprdbkp.status , backup.status  along with fields some are same or may different

now in dashboard i want to store  table name into variable and want to use this table name in expressions

like  v1=' nonprdbkp'

then v1.field

please guide how to do this ?

Vikas

[Mark_Little]

Hi Vikas,

I am not a 100% on how you are going to achieve this, but his maybe a way to approach.

You have the the $Table box, you can added this on as a list the to the dashboard.

Create your variable  v1 - =GetFieldSelections($Table).

On select you can use the this is your set analysis or if stataements

IF(v1 = 'table one',then,else )

Mark

[rubenmarin]

Hi Vikas, if v1 has the value 'nonprdbkp', you can try with:

$(v1).field

[Anonymous]

try this

$(v1).field