Function null() - Qlikview Server vs Qlikview Desktop

[#1]

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

[avinashelite]

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

Could you share the screenshot of the issues ?

[#3]

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

[Anonymous]

Try this and see in server

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

[avinashelite]

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 ?

[#6]

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

[#7 · Accepted solution]

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

[Anonymous]

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