Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
h_prakash
Not applicable

Converting Null Values in to Blanks in Qlik Sense

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

Tags (1)
6 Replies
sunny_talwar
Not applicable

Re: Converting Null Values in to Blanks in Qlik Sense

May be use this

NullAsValue ‒ QlikView

or just do this

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

h_prakash
Not applicable

Re: Converting Null Values in to Blanks in Qlik Sense

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
Not applicable

Re: Converting Null Values in to Blanks in Qlik Sense

Would you be able to share a sample?

kaushik_solanki
Not applicable

Re: Converting Null Values in to Blanks in Qlik Sense

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
Not applicable

Re: Converting Null Values in to Blanks in Qlik Sense

Hi Sunny, Please find the Sample file.

BTW I am facing this issue in Qlik Sense.

Thanks'Hari

h_prakash
Not applicable

Re: Converting Null Values in to Blanks in Qlik Sense

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

Thanks

Hari