Converting Null Values in to Blanks in Qlik Sense

[h_prakash]

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
1	2015
1	2016
2
3	2014
4	2015

Thanks

[sunny_talwar]

May be use this

NullAsValue ‒ QlikView

or just do this

If(Len(Trim(Year)) = 0, ' ', Year) as Year

[h_prakash]

Hi Sunny,

Thank you for responding. Project Number and Year are coming from two different tables. In front end if I want to create a table chart I a facing this issue.

I have tried the solutions which you have mentioned..still getting the issue.

In addition to this I have tried isNull function as well.

[sunny_talwar]

Would you be able to share a sample?

[kaushiknsolanki]

Hi,

Check I have given 2 ways.

1. With If statement

2. To change the missing and null symbol from presentation tab of straight table.

Regards,

Kaushik Solanki

[h_prakash]

Hi Sunny, Please find the Sample file.

BTW I am facing this issue in Qlik Sense.

Thanks'Hari

[h_prakash]

Thanks for responding Kaushik. I am facing this issue in Qlik Sense.

Thanks

Hari