Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

narendiran
Contributor

getactivesheetid() issue

Hi All,

I have an issue with GetActiveSheetId().

if (GetActiveSheetId()='Document\Dashboard',Red(),Blue()). It works most of the time but sometimes it goes blank and gives Yellow default colour on the bar chart. Does any came across this issue in the past?

Please help me out if there are any quick fix.

Tags (1)
1 Reply
micheledenardi
Valued Contributor

Re: getactivesheetid() issue

Hi,

try to put getactivesheetid() on a textbox and see which is the returned value when the bar became yellow.

Another things you can try is to put your formula in uppercase like:

if (upper(GetActiveSheetId())='DOCUMENT\DASHBOARD',Red(),Blue())

hope it helps

Community Browser