Hi all. So QlikView treats null values oddly, in that you can't select the "-" value when it appears in the chart. I know in the script you can do a null string replace when creating the tables, but this doesn't help when you're relating two different tables. For instance, say I have two tables that relate to each other, and I create a chart that has a field from one table on the X axis, and a field from the other table on the Y axis. So on this chart, I'll get a plot of values, and then I'll get one bar on the X axis that says "-". This signifies that there is no relationship between the two tables for those particular rows. I still want to be able to select that though. Is there any way to do this? If not, feature request?
