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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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