12 Replies Latest reply: Aug 6, 2016 7:17 AM by Vineeth Pujari RSS

    NULL Value

    Deepanshu Chamoli

      Hello All

       

      Please help me in the below query. I do not know if it is possible or not in Qlik Sense

       

      Please suggest.

       

      In the below attached screen shot,for Bar graph, I have NULL value in the data. I want to use the formula which tells that when there is value it shows the amount and when there is no data it shows the comment that "Data is not available". Just like the Pie-Chart takes default comment.

       

      Formula I used:

       

      IF(len(trim(Department)) > 0, Sum(Amount))

       

      Please suggest.

       

      Thanks

      DC