topic Generating data in Bar chart or backend in QlikView

Generating data in Bar chart or backend

hitha1512 — Tue, 14 Feb 2023 19:52:53 GMT

Hi Team,

I am calculating availability of Devices. On selecting one device i get the below data. Is there a way i can populate 100% for months this device has no data on ? provided my entire data set starts from June 2022.

June - 100% , July - 93.03% (as displayed below), August- 100% , Sep - 100% and so on

Re: Generating data in Bar chart or backend

edwin — Tue, 21 Feb 2023 16:49:32 GMT

this means there are no records associated to the selected dates. you can force a measure ignoring the device.

if(count(Device)=0, sum({<Device=>}1), sum(Measure))

if Device is the selected device, and sum(Measure) is your expression. this means if there are no devices for the month, return sum(1) ignoring selected Device, else - normal expression