Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Would you be able to share a sample?
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
Hi Sunny, Please find the Sample file.
BTW I am facing this issue in Qlik Sense.
Thanks'Hari
Thanks for responding Kaushik. I am facing this issue in Qlik Sense.
Thanks
Hari