Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to select null "-" value in charts

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?

0 Replies