topic Re: Null vs 0 in Line Chart in QlikView

Null vs 0 in Line Chart

cbaqir — Tue, 17 Apr 2018 16:10:12 GMT

The issue I am having is that if the Avg # of days between two selected PROCESS steps is 0, it should show as 0 and not null.

Example: DEFECT_ID = 6036

PROCESS_STEP = Ticket Created and Routed

Expression: SUM(
Aggr(
Max(PROCESS_STEP_START_DATE)- Min(PROCESS_STEP_START_DATE)
,DEFECT_ID)
)
/Count({$<DEFECT_ID = {"=Count(PROCESS_STEP) = GetSelectedCount(PROCESS_STEP)"}>}DISTINCT DEFECT_ID)

You can see from the tables that the data is showing as 0 but is not showing on the line chart. I tried an if(isnull()) but it didn't fix it. Any suggestions?

Re: Null vs 0 in Line Chart

YoussefBelloum — Tue, 17 Apr 2018 16:12:48 GMT

Hi,

try with this:

=if(len(trim(your_field))=0,...

Re: Null vs 0 in Line Chart

cbaqir — Tue, 17 Apr 2018 16:14:50 GMT

No change. I think the issue might be 0/1... but it shows as 0 in the table. I noticed that the month/year doesn't populate in the table though. Maybe that's the issue?

if(len(trim(GOV_PROCESS_QUEUE_TAT))=0,SUM(
Aggr(
Max(PROCESS_STEP_START_DATE)- Min(PROCESS_STEP_START_DATE)
,DEFECT_ID)
)

/Count({$<DEFECT_ID = {"=Count(PROCESS_STEP) = GetSelectedCount(PROCESS_STEP)"}>}DISTINCT DEFECT_ID))

Re: Null vs 0 in Line Chart

vishsaggi — Tue, 17 Apr 2018 16:22:19 GMT

Just uncheck this in your chart properties.

Re: Null vs 0 in Line Chart

cbaqir — Tue, 17 Apr 2018 16:22:59 GMT

Duh. Thanks