Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

Dollar Sign Expansion Variable within a Variable

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

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

Call the variable function with Document\Dashboard, so

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


See example (different sheet name, but same princiapl)

View solution in original post

6 Replies
stigchel
Partner - Master
Partner - Master

Call the variable function with Document\Dashboard, so

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


See example (different sheet name, but same princiapl)

MK_QSL
MVP
MVP

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

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

rustyfishbones
Master II
Master II
Author

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

but thanks

rustyfishbones
Master II
Master II
Author

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
MVP
MVP

You have selected your own answer as helpful !

rustyfishbones
Master II
Master II
Author

Sorry Manish, I have fixed that now