Discussion board where members can get started with Qlik Sense.
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.
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.
Check I have given 2 ways.
1. With If statement
2. To change the missing and null symbol from presentation tab of straight table.