topic Urgent Help Required in QlikView

Urgent Help Required

vikasmahajan — Fri, 20 Nov 2015 08:09:05 GMT

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

Re: Urgent Help Required

Mark_Little — Fri, 20 Nov 2015 08:32:19 GMT

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

Re: Urgent Help Required

rubenmarin — Fri, 20 Nov 2015 08:38:01 GMT

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

$(v1).field

Re: Urgent Help Required

Anonymous — Fri, 20 Nov 2015 08:38:09 GMT

try this

$(v1).field