Qt World Summit: Register Today!

(Q)charting sql query with null(s)

  • While (line-)charting a sql query (a sample output as below, to give you an idea of what the query looks like) with qchart, I have noticed that when the query output contains null value (in bid_vwap column), the qchart plots nothing. What are the ways to deal with such issue? If possible, I'd like qchart to charting non-nulls and skip charting nulls.

         min         |        bid_vwap        

    2010-07-01 00:00:00 | 0.84670294117647058824

Log in to reply