(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
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.