topic Re: Select report in access point in QlikView

Select report in access point

Thu, 14 Apr 2016 21:44:47 GMT

Hi All,

I have few reports in QVW with Conditions. It is working perfectly in desktop. After moving it to the server i'm unable to select the reports. Its simply goes grey out. When i disabled the conditions they are working fine in access point.

Does anybody experienced this before.

Sir, stevedark‌ i saw your post Reports not opening via AccessPoint | Qlik Community‌. My issue is similar to your comment in their.

Thanks

Walter

Re: Select report in access point

Thu, 14 Apr 2016 22:05:32 GMT

Hi Walter,

Do you have section access conditioned in the reports?

Re: Select report in access point

stevedark — Thu, 14 Apr 2016 22:11:04 GMT

What code do you have in the Conditions?

If, rather than removing the conditions, you place in code that will always evaluate to true, e.g. 1=1, do the reports show correctly then?

I certainly have customers who have reports that show / hide on conditions and this works as advertised.

Which version of QlikView are you experiencing this with?

Steve

Re: Select report in access point

Fri, 15 Apr 2016 13:37:38 GMT

Hello Sir,

Thanks for the reply.

Heres is the conditoin : if(GetActiveSheetId()='Document\SH43','1','0')

its QV 11.2 SR10

Re: Select report in access point

marcus_sommer — Fri, 15 Apr 2016 13:42:16 GMT

Try to adjust your condition to something like:

if(GetActiveSheetId()='Document\SH43',true(),false())

'0' or '1' are simply strings and only false() respectively 0 will be treated as false and everything else is true.

- Marcus

Re: Select report in access point

stevedark — Fri, 15 Apr 2016 14:08:34 GMT

Hi,

The IF part of that statement is superfluous, as the inner part returns a Boolean that can be used by the condition. Try with simply this:

GetActiveSheetId()='Document\SH43'

As marcus_sommer‌ points out, the fact you have the 1 and the 0 in single quotes is making them strings, which may not evaluate correctly. It's interesting it works in Desktop but not server - but there you go...

Hope that helps,
Steve

Re: Select report in access point

Fri, 15 Apr 2016 14:55:35 GMT

Thank you Sir,

Infact i applied your condition too.... It solved the issue.

Very helpful

Re: Select report in access point

Fri, 15 Apr 2016 14:56:29 GMT

Thank you Sir,

Thank you so much for your time.