I'm trying to realize a new qlikview document based on a mysql script that is not so clear for me
SELECT sum(numPages) AS NUMPAGE, (SELECT count(numpages) from MYTABLE where doctype= 'ORDER' and left(DATE_FORMAT(FROM_UNIXTIME(LEFT(ORDERDATE, LENGTH(ORDERDATE) -3)), '%Y%m%d'),6) = left(DATE_FORMAT(FROM_UNIXTIME(LEFT(tb.ORDERDATE, LENGTH(tb.ORDERDATE) -3)), '%Y%m%d'),6)) AS NUMDOC,
left(DATE_FORMAT(FROM_UNIXTIME(LEFT(ORDERDATE, LENGTH(ORDERDATE) -3)), '%Y%m%d'),6) AS ANNO
from TABLE. documents as TB where (doctype= 'ORDER' )
and not hash is null group by left(DATE_FORMAT(FROM_UNIXTIME(LEFT(ORDERDATE, LENGTH(ORDERDATE) -3)), '%Y%m%d'),6)
I underlined what I don't understand. I think it should group by year and month, but what does it means "..and not hash is null " ?
