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.