I want to ask about expressions of Null and Zero Value.
The attached file has a sample data set. In particular, assets submitted include Null and Zero.
When I add an Excel datasheet, 2000 is null and 2007 is 0 in the asset field. When I upload this data to qlik, it seems to show 0 in both 2000 and 2007.
I want to implement a line chart. In 2000, there is a way to represent the year, but is there a way to represent it as NULL rather than 0? I know that in this case, the lines in the chart may be cut off.