topic Re: Expression not working on different server in QlikView

Expression not working on different server

Thu, 29 May 2014 13:15:53 GMT

Hi,

I have written the following expression in a text_object: =count(if(closedate = null() and priority = 'Priority 1', priority))

On my computer which is a Windows XP machine (32-bit) the code is working fine and pulling through a value of 1.

However when I transfer this over to the Qlik Server which is a Windows 2008 (64-bit), the same expression is pulling through a value of 0.

I have set the ODBC drivers to force 32-bit and reloaded but this makes no difference.

I am using the following Qlik Versions:

My Computer: Qlikview 11.20.12235.0 SR5

Qlik Server: Qlikview 11.20.12235.0 SR5 64-Bit Edition (x64)

Would someone be able to help me on this please?

Regards,

Jon Ditchfield

Re: Expression not working on different server

Thu, 29 May 2014 13:28:24 GMT

try Len(Trim(closedate)) = 0 install for closedate = null()

I have had issues in past where null() or IsNull() has not worked as expected

Re: Expression not working on different server

erichshiino — Thu, 29 May 2014 13:29:25 GMT

Hi,

You can try isnull(closedate) and priority = 'Priority 1' in your text box.

You can also create a flag on your script and change this expression to use set analysis. You will probably experience a better performance.

In script, you can create something like this:

Load ...

if( isnull(closedate), 1, 0 ) as null_closedate,

...

Then, you expression will become:

count ( {<null_closedate={1}, priority={'Priority 1'}> priority}

Best Regards,

Erich

Re: Expression not working on different server

Thu, 29 May 2014 13:36:19 GMT

Hi,

Unfortuately this didn't work. It is working fine if I access my document from my pc, its when I access the document from the server is when the data doesn't come through.

Regards,

Jon

Re: Expression not working on different server

Thu, 29 May 2014 13:39:06 GMT

64-bit resonates with the Len()=0 test. Try it in script as well as Erich suggests, it has to work.

I tried in 32-bit and 64-bit environments and both times worked in desktop and server

Re: Expression not working on different server

thomas_wang — Thu, 12 Jul 2018 02:35:32 GMT

Hi,

This might be a bug of this specific version (11.20.12235.0 SR5). When you try to get the server to calculate “Count(Null())”, A lot of things can go wrong! Try to avoid this calculation,then they will go back to normal.

Hope that may help you.