6 Replies Latest reply: Jul 10, 2017 4:10 PM by Hari Nag RSS

    Converting Null Values in to Blanks in Qlik Sense

    Hari Nag

      Hello Experts,

       

      I have a Scenario where I need to create a table with 2 dimensions.

      Here Project Number and Year are coming from two different tables. So if we create a table for Project Number 2, Year we are '-'.

      I want to convert it in to Blanks(' '). as Year is not present for that project.

      I am getting the first table. But the desired result should be 2nd table. Please help in this regard.

       

      Project Number

      Year

      1

      2015

      1

      2016

      2

      -

      3

      2014

      4

      2015

       

       

           Project Number         Year
      12015
      12016
      2
      32014
      42015

       

       

      Thanks