topic Field event trigger not working with getactivesheetID in QlikView

Field event trigger not working with getactivesheetID

Tue, 24 Jan 2012 00:19:12 GMT

I have a field on which I am trying to apply Active Sheet Trigger.

To get currently active SheetID , i use the following syntax

vActiveSheetID= chr(39)& right(getactivesheetid(),4)& chr(39) = 'SH01'

In field event trigger, I use the variable vActiveSheetID and it does not recognize the variable I have created.

But, when I hardcode the value 'SH01'. The trigger works just fine

Trigger Syntax: IF(getSelectedCount(InvoiceDate)='1','SH01','SH02') works fine

Variable Reference Sytanx = IF(getSelectedCount(InvoiceDate)='1',vActiveSheetID,'SH02')

Can someone direct me what I am not doing correctly?

Much appreciate your time

Thank you

disqr_rm — Tue, 24 Jan 2012 00:48:02 GMT

Try

Variable Reference Sytanx = IF(getSelectedCount(InvoiceDate)='1',$(vActiveSheetID),'SH02')

Tue, 24 Jan 2012 01:20:36 GMT

That did not help either

disqr_rm — Tue, 24 Jan 2012 01:26:19 GMT

Post a sample qvw here.

Mon, 21 May 2012 13:39:50 GMT

Try to loose the chr(39) in your variable. The variable itself will be a string, and therefor you do not need them in your expression.