topic getactivesheetid() issue in QlikView

getactivesheetid() issue

narendiran — Mon, 31 Jul 2017 13:54:50 GMT

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.

Re: getactivesheetid() issue

micheledenardi — Tue, 01 Aug 2017 17:05:35 GMT

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