topic Function null() - Qlikview Server vs Qlikview Desktop in QlikView

Function null() - Qlikview Server vs Qlikview Desktop

Mon, 03 Apr 2017 11:40:49 GMT

Hi everyone ,

I have an issue with the function null().

In my dashboard there is a table with a calculated dimension : if(Var1>0,null(),1) and the box "Suppress when value is null" is checked

What I want ==> Only the lines when Var1 is not null

What I see ==>

- Locally : Only the lines when Var1 is not null

- In Server : No lines at all

I don't understand why the null() function works perfectly locally but not in the server.

Did someone has an idea ?

It worked in the server before (new data) so I don't understand what happens ...

Kind regards ,

Gwendaline

Re: Function null() - Qlikview Server vs Qlikview Desktop

avinashelite — Mon, 03 Apr 2017 11:57:09 GMT

check is their any selection in the server because it should be in sink .

Could you share the screenshot of the issues ?

Re: Function null() - Qlikview Server vs Qlikview Desktop

Mon, 03 Apr 2017 12:34:47 GMT

Hi Avinash ,

Here are 3 screenshots : locally and on server.

Local : it's ok

On server : everything is ok for example 1 & example 2 but there is an issue with example 3

Exemples 1 & 2 :

Example 3 :

I unchecked the box "Suppress when value is null" to see the difference.

I don't see any active selection in the server.

Kind regards ,

Gwendaline

Re: Function null() - Qlikview Server vs Qlikview Desktop

Anonymous — Mon, 03 Apr 2017 14:23:22 GMT

Try this and see in server

if(len(Var1)>0,Null(),1)

Re: Function null() - Qlikview Server vs Qlikview Desktop

avinashelite — Mon, 03 Apr 2017 14:37:23 GMT

Do you have the Section access implemented in the document ??? then as per the access you seeing the data reduction

can you do a clear all in the selection in Server ?

Re: Function null() - Qlikview Server vs Qlikview Desktop

Thu, 06 Apr 2017 08:10:47 GMT

Hi ,

Yes, there is a section access implemented because I need one : user A can only access to data of country 1 and user B can only access to data of country 2.

There is no more issue when I unchecked the box about the data reduction but there is no section access and user see all the data.

How can I fix this ?

Kind regards,

Gwendaline

Re: Function null() - Qlikview Server vs Qlikview Desktop

Thu, 06 Apr 2017 08:14:40 GMT

Hi ,

I can close this ticket.

The solution is to check the box about initial selection and not the box about the data reduction.

Thanks for your help !

Kind regards ,

Gwendaline

Re: Function null() - Qlikview Server vs Qlikview Desktop

Anonymous — Thu, 06 Apr 2017 15:13:15 GMT

Hi Gwendaline,

I'm glad to hear you resolved your issue. Please take a moment to Qlik Community Tip: Marking Replies as Correct or Helpful.

Thank you,

Qlik Community Team