Hi...Im new Qliksense ,I have a trend graph line..and these values show as time differences for orders per customers
This is the sort of question to ask how to stop showing 0 however
This measure is worked out using an if statement.. within the if statement there is sum difference between two time stamps.
if("CheckDate" < StartCheckDate , max({$<[Temperature]={'<=0'}>} CheckDate) - min({$<[Temperature]={'>0'}, CheckNumber = {1}>} CheckDate), max({$<[Temperature]={'<=0'}>} CheckDate) - min({$<[Temperature]={'>0'}, CheckNumber = {2}>} CheckDate))
However some customers are showing up as 00:00:00 how do I in the measure say don't show these customers.. that have 00:00:00
niana
