topic Re: Dollar Sign Expansion Variable within a Variable in QlikView

Dollar Sign Expansion Variable within a Variable

rustyfishbones — Wed, 15 Apr 2015 15:33:23 GMT

Hi All,

I have a conditional color expression

if(GetActiveSheetId() = '$1',$(color.bg.active.nav),$(color.bg.inactive.nav))

I have tried then using the following variable where my sheet ID is called Dashboard

$(v.nav.bg(Dashboard))

Do I need to wrap this in another dollar sign expansion

Any Ideas

stigchel — Wed, 15 Apr 2015 15:45:16 GMT

Call the variable function with Document\Dashboard, so

$(v.nav.bg(Document\Dashboard))

See example (different sheet name, but same princiapl)

MK_QSL — Wed, 15 Apr 2015 15:45:22 GMT

Change the variable definition of v.nav.bg as below

if(WildMatch(GetActiveSheetId(),'*$1'),$(color.bg.active.nav),$(color.bg.inactive.nav))

rustyfishbones — Wed, 15 Apr 2015 15:54:59 GMT

Thanks a lot, a schoolboy error on my part, I should have know that

but thanks

rustyfishbones — Wed, 15 Apr 2015 15:57:46 GMT

Hi Manish,

This also works thanks alot.

I will probably use your option as it's less maintenance that typing Document\ each time

Regards

Alan

MK_QSL — Wed, 15 Apr 2015 15:58:57 GMT

You have selected your own answer as helpful !

rustyfishbones — Wed, 15 Apr 2015 16:27:40 GMT

Sorry Manish, I have fixed that now