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
