topic show 0 on chart qlik sense in App Development

show 0 on chart qlik sense

joeybird — Sat, 26 Aug 2017 16:29:50 GMT

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 — Sat, 26 Aug 2017 23:40:38 GMT

See if this helps

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

joeybird — Tue, 29 Aug 2017 09:16:24 GMT

did not work sorry

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

Please help

joeybird — Wed, 30 Aug 2017 13:18:35 GMT

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