Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
check is their any selection in the server because it should be in sink .
Could you share the screenshot of the issues ?
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
Try this and see in server
if(len(Var1)>0,Null(),1)
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 ?
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
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
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