show 0 on chart qlik sense

[joeybird]

Hi

using a weeks as a dimension  weekend(OrderDate)

trend line chart

MissedOrder column in the load is 1 or null

i have in the set analysis measure as follows count( distinct {$<MissedOrder = {'1'}>} OrderID)

this shows how missed orders have been processed every week...

however i want to show the sometimes weeks that have no missed orders as 0 on the trend line 

how do i do this please

please help

[sunny_talwar]

See if this helps

Count(DISTINCT {$<MissedOrder = {'1'}>} OrderID) + Avg({1} 0)

[joeybird]

Hi

did not work sorry

Sorry also the MissedOrder column in the load is 1 or 0

Please help

[joeybird · Accepted solution]

Hi

got it working

if (count(distinct{<MissedOrder = {"1"}>}[OrderID])  =0 , '0', count(distinct{<MissedOrder = {"1"}>}[OrderID])) +

if (count(distinct{<MissedOrder = {"0"}>}[OrderID])  >=1 , '0', count(distinct{<MissedOrder = {"1"}>}[OrderID]))

thanks team