Bar chart shows value different on data point

anisha_nan — Wed, 22 Dec 2021 16:08:25 GMT

Hi,

I am showing a bar chart in qliksense where in one dimension and one measure is been used:

Dimension : System

Measure : we need to display which all Operations have not started last 48 hours by System.

I am using below Measure expression :

Count( distinct if(Isnull(StartDate),Operation,System))
+
(
Count(distinct Operation)
-
Count(distinct IF ( NOT IsNull(
if
(

((Date(Date#(Timestamp(aggr(NODISTINCT Max(Date(StartDate)),Operation)),'MM/DD/YYYY hh:mm:ss TT'),'MM/DD/YYYY hh:mm:ss')) - (v48HoursAgo)) <'00',NULL(),

1
)
), Operation,System))
)

Now issue is for some of the cases its shows correct count value on Bar chart if we select any System filter but it some cases it doesn't show correct count value on bar chart.

for last 48hours i have created a variable as v48HoursAgo : Date(now()-2, 'MM/DD/YYYY hh:mm:ss') and used in expression

Please check my expression measure where i am going wrong.

Regards

topic Bar chart shows value different on data point in App Development

Bar chart shows value different on data point