5 Replies Latest reply: May 9, 2016 7:12 AM by Stefan Wühl RSS

    Isnull function in Qliksense?

    Syed Shah

      Hi,

       

      I have created some variables in the loadscript. At the end of loadingscript, I have again nullified the variables like this

       

      Let _SavingEnabled = null();

       

      When I execute this in normal Qlikview file and then in Qlikview textbox, I type

       

      isnull(_SavingEnabled)

       

      I get a -1 values which means the variable has been nullified

       

      When I use the same loadingscript in Qliksense and then I type the same expression in a text

       

      isnull(_SavingEnabled)

       

      I get a 0 value.

       

      When I try to type the variable in the text box both _SavingEnabled or $(_SavingEnabled), the text box does not show anything. It is empty

       

      When I try len(_SavingEnabled), it is again 0. Then why is Qliksense showing 0 for the expression isnull(_SavingEnabled). I think that somehow Qliksense is not nullifying the value ?

        • Re: Isnull function in Qliksense?
          Stefan Wühl

          I can't reproduce this. I do get -1 returned from =isNull(vVariable) also in QlikSense.

           

          Do you still see the variable in the variable editor?

           

          Can you upload a small QVF that demonstrates your issue?

            • Re: Isnull function in Qliksense?
              Syed Shah

              Hi,

               

              Here is a sample document attached. I am still getting 0

               

              Regards

              Arif

                • Re: Isnull function in Qliksense?
                  Stefan Wühl

                  I think your issue is that the variable once survived the reload and made it to the front end.

                   

                  Now, even if you nullify the variable in script, it is still present in the UI.

                   

                  Delete your variable once using the variable editor in the UI, then reload.

                   

                  Now you should see -1 returned from your expression.

                   

                  I think QlikView will show the same when the variable is present in the UI.

                    • Re: Isnull function in Qliksense?
                      Syed Shah

                      Many thanks for the reply. I have two more questions

                       

                      1) Where can I find the variable editor in the Qliksense

                      2) Even if the variables survives on the front end, should the statement Let Variable = null() not nullify it anyway even if the variable was declared on the front end?

                       

                      Regards

                      Arif

                        • Re: Isnull function in Qliksense?
                          Stefan Wühl

                          1) Enter edit mode in the UI, then click on the small icon in the lower bar.

                           

                          SenseVariable.png

                           

                          2) I guess that's because NULL is not a value and can't be stored in a variable.

                           

                          When the variables evaluates to NULL in the script, it should be removed completely (but with the exception stated in my previous post, when the variable once has reached the UI). You need to aks someone from Qlik to get answered why it is this way.

                           

                          In the UI, you can only assign an expression that evaluates to NULL, but not NULL directly.